Results 1 to 3 of 3
  1. #1
    britt britt is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    3

    Combox not filling the rest of the form

    I wasn't sure what to put in the title but basically this is my problem. I don't know anything about writing code or anything, i've just been using the wizards in Access 2007 for designing my database.

    I have a form that has some of the following info from a table:

    Parent Company
    Address
    State
    Zip

    I made a combo box that has lets me choose the parent company and then autofills the rest of the information. My problem is that it auto fills any "Parent Company" except one.



    For example... the choices in the combo box are:

    Swedish Medical Center
    Children's Health Clinic
    Auburn Surgery Center
    Bellingham Regional Hospital

    If I select Swedish, Auburn or Bellingham, the form fills in all the values it should. When I select Children's Health Clinic, it fills the form with whatever the last value selected in the combo box was.

    I looked on my table and all the information/values seem to be fine.

    Anyone know why it is only not working for that one value?

    Britt

  2. #2
    britt britt is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    3
    ok... I think I figured it out. For some reason it won't autofill the form if the Combo Box value has an apostrophe (') in it...

    anyone heard of that before or know how to make it auto fill with the apostrophe?

  3. #3
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    It may be the way the Access is creating the link criteria if you replace any single quotes with Chr(34) access will find them better.

    David

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filling in a table via a form
    By janjan_376 in forum Forms
    Replies: 1
    Last Post: 07-06-2009, 01:57 AM
  2. Replies: 3
    Last Post: 02-20-2009, 02:28 PM
  3. Auto filling form fields
    By adamch29 in forum Forms
    Replies: 1
    Last Post: 07-25-2007, 06:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums