Updating with forms

G

Guest

Using Access 2002. A form based on a query in general allows for data entry.
However when I add another specific table and its link to the main source of
the query (another table) the query/form prohibits produces a result but does
not allow for data entry/update? How do i determine what is causing this? i
remove the linked table from the query and the resultant form now allows for
updating/data entry.
 
J

Jeff Boyce

Victor

Use "updateable query" as a search topic in Access HELP or on-line. Not all
queries are updateable, since Access may not be able to tell from the
query's fields which record(s) are to be updated.

Regards

Jeff Boyce
Microsoft Office/Access 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

Stop advancing in form with the "next" arrow at end of "list" 3
query from either of 2 forms 3
Form stopped accepting input 3
Using Form Query to Load Multiple Tables 2
Main Form with Subforms 5
Which is faster? 6
Need Carriage Return after Data Entry 1
blank form, can't insert new record 11

Top