Go To Current/Selected Record Problem

[thinkwelldesign]

Hi,

I have a form with a subform that I am using. I have a dropdown bo
that lists business projects, and then the subform lists the record
associated with the project selected. Pretty usual so far, I suppose.

Then, when I doubleclick a subform record, I have a macro written whic
opens a form. I want this form to open to the record that I ha
doubleclicked on in the subform. Is there any way to open "any form" t
a specific record that I had selected in some other form or query?

TIA,

Dav

 

[Rick Brandt]

Hi,

I have a form with a subform that I am using. I have a dropdown box
that lists business projects, and then the subform lists the records
associated with the project selected. Pretty usual so far, I suppose.

Then, when I doubleclick a subform record, I have a macro written which
opens a form. I want this form to open to the record that I had
doubleclicked on in the subform. Is there any way to open "any form" to
a specific record that I had selected in some other form or query?

Drop a new command button on your subform with the wizard enabled. One of the
choices for the command button wizard does exactly this. Afterwards you can
copy the code created for the button's Click event to the desired double-click
event and then delete the button.

 

[Albert D. Kallal]

The code behind the buttionshould be:


me.refresh
docmd.OpenForm "theform",,,"id = " & me.id