Need help with form on Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2003 form that I've created with fields from 5 different
tables. I've created sections in the form for each part that relates to a
specific table, so it is somewhat separated by a "category" (which are the
tables).

I've added a command button to the form that will allow a user to search for
a name in order to bring up one to edit. The search works perfectly.

Here's my problem. When I add a new record to the form, it appears I have
to fill out at least one field that concurs with each table. None of the
fields are required fields. If I do not fill out at least one field from
each table, when I attempt to do the search for that name, it does not
appear. However, if I go back to the table, it has added the record.

If I do fill out at least one field from each table, then do the search, the
record is found. I don't get it. Does anybody have a clue here?

Thanks in advance!
 
I have an Access 2003 form that I've created with fields from 5 different
tables. I've created sections in the form for each part that relates to a
specific table, so it is somewhat separated by a "category" (which are the
tables).

I've added a command button to the form that will allow a user to search for
a name in order to bring up one to edit. The search works perfectly.

Here's my problem. When I add a new record to the form, it appears I have
to fill out at least one field that concurs with each table. None of the
fields are required fields. If I do not fill out at least one field from
each table, when I attempt to do the search for that name, it does not
appear. However, if I go back to the table, it has added the record.

If I do fill out at least one field from each table, then do the search, the
record is found. I don't get it. Does anybody have a clue here?

Thanks in advance!
Click to expand...

You're remarkably lucky that you can update this monster at ALL. <g>

Normally one would NOT create One Grand Master Query linking all your
tables. If you have one-to-many relationships, it's usually much
easier to use a Form based on the "one" side table, and one or more
Subforms based on the "many".

How are your tables related? What are their Primary Key fields, and
how have you joined them in the Relationships window? (If you haven't
done so... perhaps you should consider it).

John W. Vinson[MVP]
 
Back
Top