Filter for Multiple Queries/Combo Box

[finance600man]

All,

I am attempting to use a macro built behind a command button. There are no problems with it, however, I cannot create a statement which would apply to all the queries running.

What I am trying to do is create a prompt or input that would apply to all the queries (input date). The way it is setup currently, it is asking me for a date prompt on every single query as it runs. Would I be better off to write a form in VB?

The second part of the question is on a combo box I built. The box uses the drop-down menu from a table. It is using VB such that when the change happens, it should apply the change to the query that runs after the change. In the filter section of the query it says to refer to the date being selected from the combo box. My problem is that every time I attempt to make a selection it tells me there is some kind of error related to date.



Any input would be greatly appreciated.

[NTC]

In part 1 - the approach to take is not to use parameter queries that force a parameter prompt as each query opens. Instead; have a textbox in your form that holds the date - and have those queries call that info. Syntax in your query criteria would be something like this:
Forms!YourFormName.TheDateTextBoxName

As to part 2; if a combobox is throwing "some kind of error related to date" when you attempt to make a selection - - why is difficult to ascertain from the info posted. You might simply consider deleting that combobox and making a new one fresh.

hope this helps a little.

[finance600man]

With respect to part 2, I tried to retrace my steps on a new box, but I am not sure where the error has occured. Can you offer some troubleshooting advice? I can't exactly figure out how to trace the error.

In part 1 - the approach to take is not to use parameter queries that force a parameter prompt as each query opens. Instead; have a textbox in your form that holds the date - and have those queries call that info. Syntax in your query criteria would be something like this:
Forms!YourFormName.TheDateTextBoxName


As to part 2; if a combobox is throwing "some kind of error related to date" when you attempt to make a selection - - why is difficult to ascertain from the info posted. You might simply consider deleting that combobox and making a new one fresh.

hope this helps a little.

[NTC]

The answer depends on exactly when the error shows. If the error occurs when you attempt to select inside the combobox (which was my first impression) - making a new combobox would be a first step.

If the error occurs when the query runs - - then one must inspect that more closely. Not sure I can do that based on the info posted.