Consulting

Results 1 to 2 of 2

Thread: Form Selection (from combo list) not saving to table

  1. #1
    VBAX Contributor
    Joined
    Jul 2011
    Location
    Manchester
    Posts
    142
    Location

    Form Selection (from combo list) not saving to table

    Hey everyone.

    I have a form within a database i set up which can be auto populated on the whole by selecting a code from a drop down list which works fine. The table that generates this information has a filed called TRUST which originally had no information in it so i created a another field (combo) with a list of options to choose from.

    The main form populates and saves back to the table when a code is selected with no issues but the TRUST field will not save UNLESS a code is selected which may not always be an available option.

    The drop down combo for trust appears in both the form and table but unless that original code is selected it will not save at all. can anyone tell me what i have done wrong please?

    It's like the form won't activate at all unless that original code is selected and i tried a dummy code but it just populates the form with data from the first record in the table

    Thank you

    Mykal

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Mykal, you say "I have a form within a database i set up which can be auto populated on the whole by selecting a code from a drop down list which works fine."
    How does it do this?
    Does the form have an underlying Record Source?
    Is it updateable?
    Is the TRUST field part of that record source?
    I don't like Table based drop downs, I prefer to create them as required on the form.
    Does the Table drop down work OK?
    Can you posts a database with some dummy data?

Tags for this Thread

Posting Permissions

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