TaylorLeigh said:
I have the following tables from which to create my form:
Organization - Subspecialty - Customers - Orders - Orders Details. After
I
have created the form I cannot enter data in some of the places. If I
look
at the tables, they seem to flow perfectly from one to the other, but the
form is not working properly. What am I doing wrong?
Without more details it's hard to say. It depends largely on how the form is
linked to the underlying table(s). Queries that join tables in certain ways
may not be updatable, which means your form will display records but not
allow additions/changes. For example: as a rule, it's not a good idea to
base a form on a query that contains Joins, because if you're not careful
the query will be non-updatable, particularly if more than 2 tables are
involved. Usually, the best design involves a main form bound to one table
and subforms bound to related tables. Combo boxes can be used to provide
look-up options for a field that is a foreign key to a related table. Just
as an example: Customer ID might be a field in your Orders table, and it
probably is a foreign key linked to the Customer ID field in the Customers
table. You can use a combo box control on your form to provide a list of all
Customer IDs for the user to select from (using the Customers table as the
Row Source), and the selected value will be placed in the Customer ID field
in the Orders table (by putting Customer ID in the Control Source property).
Without actually seeing your form and the query it is based on, I can't give
much more advice than that. You might want to post back (start a new post,
not a reply to this one) with more details. Try to describe specific
problems and ask specific questions, and include as much information as you
can to reproduce your problem.
Carl Rapson
