forms using two tables

S

Splinter

I have created a form using form wizard and info from two tables. However
the form will not accept either a new record or amendment to an existing
record. I can however amend either of the two tables in table format. Can
anyone tell me what the problem is? I am using Office 2002 although I note
the database says 2000
 
D

Douglas J. Steele

The only way to be able to use 2 tables at once in a form is to join them
using a query. If you've done that, is the query updatable?
 
S

Splinter

Have raised the query and used form wizard for the form. Edit is set to yes
but I still can'e input, is there something else I need to do?
 
P

paul_p_francis

Hello Doug,

I am in need of inserting into two tables using one form with Access 2002.
The form has 8 fields. All 8 are needed for Tbl1 but only a select 3 are
required for Tbl2. Based on your statement, is Expression Builder the place
I would create the SQL join? Additionally, should I posit this as an "After
Update" Event?

Although new to Access, I am comfortable with SQL. Where can I get more
information regarding how to accomplish this? Any help or redirection is
appreciated.

Thanks,
--Paul
 
Top