forms using two tables

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

Guest

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
 
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?
 
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?
 
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
 
Back
Top