Macro opening specific record in different formc

[CQCDave]

Thanks in advance for the help. I am using MsAccess 2007.



I have 2 forms Kit Change and Inventory.

I have created a macro to open a corresponding record in a different form.
From the Kit Change form i have a button to Open Form
Form Name Inventory
View Form
Where Condition [ItemNumber] Like [Inventory]![Item #]

This prompts me to enter Item Number. I want it to display the corresponding record from the inventory form without entering the prompt.

Thanks...

[pbaldy]

If you want to use VBA:

BaldyWeb wherecondition

To stay with a macro, you use the full form reference:

Forms Refer to Form and Subform properties and controls

[CQCDave]

Thanks for the help...

[pbaldy]

No problem.