Adding new records help!

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

Guest

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.
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acnewrec? 1
Access Automatically Send a notification email once a record is added 0
Generating a new Record 14
Suggestion for Structural Approach? 3
Delete Duplicate records 1
Requery problem 2
Find A Record In Any Linked Table 1
Bullets and Hyphens 3

Back
Top