Greetings,

I've got a main form with four subforms for adding or editting data. The subforms are for comments about various aspects of the main form.

The main form is unbounded. I've done this because I don't want the user to commit the changes/additions until they hit the Save button at which time changes are made to the underlying databases.

Briefly the structure is as follows (main form composed of a query of 4 tables):



Main Form _______________SubForms
WellLocationNumber _______WellLocationComments
DateLoggerSerialNumber____ DataLoggerComments
CableSerialNumber _________CableComments
LoggingEventNumber _______LoggingEventComments

In my code, I inserted:
Me.SubFormDataLoggerLocationComments.LinkMasterFie lds = Me.TextBoxSWN.Value
Me.SubFormDataLoggerLocationComments.LinkChildFiel ds = Me.TextBoxSWN.Value

The code work but I get a message box saying "Enter Parameter Value" containing the actual value of my well location number (i.e., "14N01E35P004M"), like when you do a "booboo" in a query.

I don't know. Maybe, my logic is too convoluted. Now to take this a step further, I'd really like to use temp tables for my comment subforms if adding a record, or the existing tables if editting a record. Again, it's because I don't want those added comments committed to the table until the Save button is pressed (in the case of a new parent record).

Any help or suggestions would be appreciated.

Thanks,

Jon Mulder
Durham, California