Dblclick subform to refocus main form

K

KateB

Hi, I'm not sure if I can explain this properly to get help but I'll have a go!

I have a mainform called AlertOrg5. At the bottom is a subform
(zz_subform1) which automatically searches the table filled by the main form
for any entries with the same surname and displays a list. I want to be able
to double click a field in the subform to display the complete record in the
main form. Each entry has a unique ID (AutoID). I know I need to put
something in the dblclick event of the subform but can't work out the format.
Can anyone offer advice please?

Thanks
Kate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Access Main form/Subform Navigation 0
Update subform with combobox change on main form 1
Setting subform to add mode while main form is in edit mode 9
subform within subform On Main for Child master link question 2
Unremovable horizontal scroll bar on subform 1
Using an append query in a subform 1
Pop-Up Subform not linking to Main Form 2

Top