Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Posts
    11
    Thanks
    0
    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
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    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.
    Regards,

    Gary
    (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
  •