forms using two tables

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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Splinter" wrote in message
...
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

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?

"Douglas J. Steele" wrote:

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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Splinter" wrote in message
...
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

My question was "If you open the query, can you make updates in it?", and
you haven't answered that question.

See
http://msdn.microsoft.com/library/en...DataQueryS.asp
for details on what makes a query updatable or not.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Splinter" wrote in message
...
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?

"Douglas J. Steele" wrote:

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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Splinter" wrote in message
...
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

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

"Douglas J. Steele" wrote:

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?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Splinter" wrote in message
...
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