find record question

[noonan1]

I have a form with a combo box listing project ids (1,2,3 etc..).I want to be able to select an ID and then click on a command button to open a form called Action_Items with the specific record relating to the id selected showing.Eg if I select project id 1 and then press the command button to open the action items form, the record for project id 1 will appear.I am relatively new to VBA and would appreciate any help thank you.

 

[Creepers]

In Access (VBA) one can pass values from one form to the next using OpenArgs

Like this...

Dim Open_Arg_Value as variant
Open_Arg_Value = 10

DoCmd.OpenForm "Form1", acNormal, , , , , Open_Arg_Value