Adding new records help!

S

Sarah Murray

Alright, i have tables, i have forms, i have queries.
I have a general form thats all like "company name, address".. blah blah blah
The information for this is stored in a few different tables, and there are
a few different queries that use the same information.
When i click on the add a new record button, a blank record certainly does
come up, but it won't let me enter in anything.
Why?
Help.
 
J

John Vinson

Alright, i have tables, i have forms, i have queries.
I have a general form thats all like "company name, address".. blah blah blah
The information for this is stored in a few different tables, and there are
a few different queries that use the same information.
When i click on the add a new record button, a blank record certainly does
come up, but it won't let me enter in anything.
Why?
Help.
Click to expand...

Probably because you've based the Form on a query which is not
updateable.

Rather than using one "Great Master Query" linking all your tables,
consider using a Form for the "one" side table, with a Subform or
Subforms for the related tables.


John W. Vinson[MVP]
 
Top