Add Record On Double Click??

[Colorado Spring]

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

 

[RuralGuy]

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.