I have a form that prompts the user for 4 or 5 pieces of information. The info is entered utilizing a mix of combo and text boxes. To run the query, the user clicks query. If a matching record is found, the form containing the results opens. Otherwise a MessageBox pops up.

The account number field will always be empty as the information is not entered by the Budget Department. I need to be able to set the Account Number to a value in a control on the Account Info form which is also open.

I tried using the default value property, but it will only accept the value if "Data Entry" = "yes". If I set it to yes, the rest of the data disappears.