Open Form with macro and data from Selected Record

[Matthew Scheperle]

I am wanting a person to open a form, and have the subform display the
records that relate to the main form. This part works. I then have a
continuous form view for the subform and i want the user to be able to double
click on the record they see in the subform and have it pull up that record
into a blank form. I get the blank form to open up when they double click,
however I cannot get the data for that record to show up. I either get a
blank/new record or all records.

I am trying the SearchForRecord macro in an On Load Event. This loads after
the form has been opened.

Action: SearchForRecord
Arguments: Form, frmLegislativeYears, First, Forms![newform]![LegYear] =
Forms![frmLegislativeYears]![Child2].Form![LegYear]


Thanks,

 

[BruceM via AccessMonster.com]

I think this link describes some way of doing what you need. Where code is
needed I think it uses VBA rather than macros, but that is a better approach
anyhow, IMHO.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

I am wanting a person to open a form, and have the subform display the
records that relate to the main form. This part works. I then have a
continuous form view for the subform and i want the user to be able to double
click on the record they see in the subform and have it pull up that record
into a blank form. I get the blank form to open up when they double click,
however I cannot get the data for that record to show up. I either get a
blank/new record or all records.

I am trying the SearchForRecord macro in an On Load Event. This loads after
the form has been opened.

Action: SearchForRecord
Arguments: Form, frmLegislativeYears, First, Forms![newform]![LegYear] =
Forms![frmLegislativeYears]![Child2].Form![LegYear]

Thanks,