select record from query within form - post to another form

[shauntck]

Hey guys, I want to run a query and select a record from that query and have it load a form i created with the data populated(according to that record).

I know I need a 2 forms (1 of them with the query in it and the other taking in a record as a parameter.

Does anyone know how to pass a record from 1 form to another (especially how to actually select the record)

Thank you so much
-shaunt

 

[PHV]

Take a look at the RecordSource property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244