I am using Access 2007.
Form A is based on a query that has a parameter prompt for something called Formatted Cost Code. Later on I developed Form B based on a query that also had a parameter prompt for the Formatted Cost Code.
I have Form A set up on the Main Menu. I then set up a button for the user to open Form B.
As I went through the wizard to create this button I checked "open the form and find specific data to display", then for the matching data I clicked on the Formatted Cost Code field for Form A and Form B. I want the user to be able to open Form B based on the value they used when opening Form A and not have to enter the Formatted Cost Code again!
This is not happening! When the user clicks on Form B it always prompts for the Formatted Cost Code.
When I checked the macro created under the On Click property of this new button it shows the following under Where Condition,
="[Formatted Cost Code]=" & "'" &[Formatted Cost Code] & "'"
Is this correct? Do I need to change something here?
