Double inquiry

[detaylor1242]

Using Access 2010, on Window 7 Pro. I have a main menu form that has a button that runs a Query Macro. However when I select that button it asks me for the consignor number of the records that I want to edit or add to. This is what it is supposed to do but when I put the number in it comes right back and asks me again. When I put it in the second time it works fine.



The query is Consignor Item Query and the Consignor Field has the ? in it. The Macro for the New/Edit Button is macEditItem that contains Query Name Consignor Item Query, View Datasheet and DataMode Edit. I have several other button that are acting the same as this one. Any help greatly appreciated.

[June7]

I don't use macros. However, I understand them and can usually figure them out. If you want to provide db for analysis, follow instructions at bottom of my post.

Why does Consignor Field have ? in it?

[detaylor1242]

In a Query the ? is what brings up the message box that asks for input. In this case I would put in the consignor number that I want the query to search for.

[June7]

Okay, it is in the Criteria row of query and that triggers popup input prompt. I never use them.

Somewhere else there is another prompt for input. Maybe in the macro. Don't know without being able to analyse.