First of all I want to thank you for responding to my problem.
I wasn't clear enough about what I am doing with the popup form. My whole database is an inventory viewer for our purchasing agent. I am the sole keyer for the main database and the one that I am writing is for purchasing to view and check on material, but not to edit.
I have a main form that views all the inventory in our yard with a command button to select (query out) only certain items. The command button opens a report, that gathers from a query identical to the main forms query with the exception of criteria being filled in. In the criteria row of 4 of the fields in the query I have [Forms]![formname]![item]. The expression above is opening a popup form with a combo box to chose criteria from. The reason behind this is that some of the names of items are too long to list, so everything is abbrev. Using a combo box makes it easier for others to choose correct criteria names.
The problem that still persists is that I have to go thru the four different popup dialogs twice with the same choices before it will run the report. The first time thru shows a blank report, the second time thru shows a completed report!
I have tried your suggestions and either I didn't do it correct or it just didn't work. So I guess my question to you now is, do you have another idea or am I going about this all wrong and you have a better way to try to retrieve the report information?
Thanks again for your prompt response and time!
[This message has been edited by jmacnwd (edited 10-18-2001).]
I wasn't clear enough about what I am doing with the popup form. My whole database is an inventory viewer for our purchasing agent. I am the sole keyer for the main database and the one that I am writing is for purchasing to view and check on material, but not to edit.
I have a main form that views all the inventory in our yard with a command button to select (query out) only certain items. The command button opens a report, that gathers from a query identical to the main forms query with the exception of criteria being filled in. In the criteria row of 4 of the fields in the query I have [Forms]![formname]![item]. The expression above is opening a popup form with a combo box to chose criteria from. The reason behind this is that some of the names of items are too long to list, so everything is abbrev. Using a combo box makes it easier for others to choose correct criteria names.
The problem that still persists is that I have to go thru the four different popup dialogs twice with the same choices before it will run the report. The first time thru shows a blank report, the second time thru shows a completed report!
I have tried your suggestions and either I didn't do it correct or it just didn't work. So I guess my question to you now is, do you have another idea or am I going about this all wrong and you have a better way to try to retrieve the report information?
Thanks again for your prompt response and time!
[This message has been edited by jmacnwd (edited 10-18-2001).]
