Add Record On Double Click?? (1 Viewer)

Morning, all...

Hoping someone can help me with this. I have a form (one-side) with a bound continuous subform (many-side). I have a second unbound subform, also continuous, which is used as a reference only (no data entry) to select the record to be added to the bound subform. Is it possible to set it up so that, when the user double clicks on the pk from the unbound subform it adds that pk as a new record on the bound subform?

Thanx in advance for your help with this ;<)

Karen

Hi Karen,
Not without some code but of course you can add the record. The bound SubForm is based on a query/table. When the user selects the record from the unbound SubForm then add the record to the underlying table of the bound subform and then requery the bound SubForm.

You are not really adding a record. What you are doing is asking one form to show the record selected in a different form. Use the Where argument of the OpenForm method to control what the second form shows.