query won't allow update without creating a record

  • Thread starter Thread starter Tmarkos
  • Start date Start date
T

Tmarkos

In Access 2003 I have just two table linked that appear to be updateable
within the query. However, after filing in the data for the first table you
must move to another record and come back to the one you were working on
before it will allow you to input data for the second table?
 
queries are not designed to update data

a database can only see 1 and i say again 1 record at any one point in
time this is noted by the black arrow on the side of the form or
datasheet

when you have a query linking two tables though the black arros is
accross the entire row it can only see 1 record if that 1 record is
the half of the query the belongs to one table or the half that
belongs to the other table. so the fast you haev to update half the
data move away to allow the database to save the informaiton then move
back to allow the database to focuse on another record is completly
normal.

as a note you should be using forms and subforms for editing data not
queries or the table directally

Regards
Kelvan
 
I do have it set up on the form, but was testing in the query that the form
is built from. It is a simple one to one relationship that works in a
different database I set up. Shouldn't I be able to combine two tables on
one form and update all the information without exiting the record?

Thanks for your help!
 
I do have a subform set up called Intake and a main form client. I have
linked them in the properties by ClientID. I also have this same subform
linked to a clientEntry form and it works fine also linked by clientID.

The link just doesn't seem to take on the general client form. FYI it did
work at one time, but just stopped. Any other suggestions?
 
build your form on the main table not a query and your sub form on the
linked table

hope this helps

Regards
Kelvan
 
Back
Top