query has one table but not updateable

[pbuethe]

Originally I based my form on a query containing three tables which have a one-to-one relationship. The recordset was not updateable. I tried changing the join type or which pairs of tables were joined. Still not updateable. Tried putting 2 tables in a subquery then joining this to the other table. Still not updateable. Tried a query containing only 2 of the tables. Ditto. Now I am trying it with only one of the tables and it is *still* not updateable. I changed it to one of the other tables still with the same result. None of the tables have duplicates. How can a query based on one table with unique records not be updateable?!? And I need it to be based on the three tables. (I cannot change the data structure.)

I have just gotten a new computer, could this be the cause somehow?

 

[pbuethe]

OK, I made a query for each of the three tables. Then made one of those the record source for the form. Then put 2 subforms on the form each based on one of the other queries. Now everything is updateable. Thanks - I got this solution from searching on the forum!

 

[pbuethe]

How can I get the focus to move from one subform to the other? I tried the following to go from the last field of the first subform to the first field of the second subform.

Private Sub EarlyIntDoc_LostFocus()

    Forms![frm58061]![sfrm58061C].Form![NursSvcDoc].SetFocus
    
End Sub

EarlyIntDoc = last control of first subform
frm58061 = the main form
sfrm58061C = subform control of the second subform
NursSvcDoc = first control of second subform

Both subforms are on the main form; they are not nested.
Thanks for your help.