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...