Basics ...

[Dega]

This is no different than an order entry db but I still cannot get the tblBookings.BookingID to the tblBookingDetails.BookingID.

I am using a main form (frmCustomers) and two subforms on tabs (datasheets).



(see attachment)

Thanks

[June7]

Need a form/subform/subsubform arrangement. Or use this technique to synchronize the two related datasheet subforms: http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[Dega]

I actually found this last night and after getting the proper subform reference on the main form it worked.

=[Forms]![frmCustomers]![frmBookings].[Form].[BookingID]

Thanks

[Dega]

I spoke a little soon ...

I can see the BookingID in subform "frmBookingDetails" using the above method which worked.

But ... this does not write it to "tblBookingDetails" and I will need this value (BookingID) for query references etc?

[June7]

Don't know why it wouldn't. Do you want to provide project for analysis? Follow instructions at bottom of my post.