Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Thanked 0 Times in 0 Posts

    Problem with lookup Box (Accesss 2000)

    I have a form with a lookup box (see attached code). When I enter a student's ss# it displays the record if they are in the database or prompts me to create a new record if they are not. The combo box displays the numbers in the 000-00-0000 format but stores them in the database as 000000000. My problem is when I import records from an identical database using an append query, the combo box displays the new records in the 000000000 format and will not retrieve the student's information. How can I ensure that the combo box recognizes the ss# in the new records as a social security #?
    Attached Files Attached Files

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Frederick, Maryland, USA
    Thanked 2 Times in 2 Posts

    Re: Problem with lookup Box (Accesss 2000)

    - It sounds as if the combo box is using an input mask if the data displays as 000-00-0000 but is stored as 000000000. Check the data type of the field you are appending. You may run into an issue if mixing numeric and text fields.

    (It's been a while!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts