Set Detail form to record double-clicked by user on datasheet

X

XP

Using Office 2003 and Windows XP;

I have a subform in datasheet view laying on a main form. The main form also
has a combo so that the user can filter the subform to view only certain
records.

I added a doubleclick event so when the user double clicks the subform
another more Detailed form opens in normal view with a record selector.

The Detail form (the one that opens on DC) is bound. Now, I have two
questions:

1) How can I get this Detail form to be set to the record DC by the user on
the datasheet subform (on the main form)?

2) How can I have the Detail form filter only to the records set by the user
in the combo box on the main form?

Your assistance is very much appreciated.
 

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

Populate main form from subform record 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
main form/subform 1
Filter main form to records with no related records in subform,maintain updateable recordset 4
subform selection to change detail record on mainform 2
2007 Problem with Subform 0
OpenForm and Navigate to Subform Record? 1
Unremovable horizontal scroll bar on subform 1

Top