> Getting multi-table queries to be updateable is tough with a couple
tables,
almost impossible with three or more (as you have found), The subforms
idea is not a kludge. It is the standard and recommended way to do this.
Thanks for the tip.
I suppose the only other alternative would be to use something like:
DoCmd.RunSql ("INSERT INTO tblOrders ( [Cust_ID] ) VALUES (" & Me!Cust_ID &
")")
In any case, I've reworked the form in question so that it uses subforms to
populate the different underlying tables. I've tried to make it look like
it's only one form by aligning the input fields using a transparent border
on the subform. The problem is Tab Order - how do I get the cursor to go to
and from the subform according to the intended design of the form?
[subForm_frmAddress]
Private Sub Country_KeyDown(KeyCode As Integer, Shift As Integer)
Forms!frmNewRecord.cmdOK.SetFocus
End Sub
This doesn't seem to work correctly... is there a better way to control Tab
Order between forms?