OpenForm in subform not working

[eyuen]

I have created a form with a datasheet subform. I would like to click on a record in the datasheet subform and have it open and displayed in another form I have created.



I have created a macro to open this second form, but it gives an error pop up box saying "Enter Paramater Value" and the lists the form/fieldname that it wants. When I enter in the appropriate key value, it brings up the correct record on the second form, but obviously, I want this to happen automatically.

The weird thing is, when I open up the subform as a form by itself (and not as a subform embedded withing another form), the macro works perfectly without any error messages, i.e. it brings up the other form opened up to the appropriate record.

Any thoughts?

Thanks.

[pbaldy]

I don't use macros, so I'd use this technique:

http://www.baldyweb.com/wherecondition.htm

The macro should work though. Since it works when the subform stands alone, it sounds like your reference to it is incorrect. Here's a good reference on the syntax:

Forms Refer to Form and Subform properties and controls

[eyuen]

I tried the wherecondition and it worked!

Thanks.

[pbaldy]

Ah good, glad it worked for you. Welcome to the site by the way!