9 replies
by shmaltz
I think that the only way to do that would be to call a function that in turn calls a form that returns the parameter to the function and then the function returns it to the query.
Anyhow i dont see any reason why you would open a query from the query tab use a form instead that calls the query and put the parameter options on the form that way when a user opens the query the query will not ask for the parameter since the form gave it allready to the query.
by mahunsaker
by mahunsaker
by glen_mcleod
Start with an unbound form. Create and populate you combo box with the appropriate information. In the "_Change" event, use the information in the combo box to build your SQL statement. Then assign the SQL statement to the form's RecordSource property. You may have to refresh your form and re-bind your controls.
Glen
by mahunsaker
by mahunsaker
by andrewf
Hi,
Why not contain all the information on one form ?
Make a form, drop a combo box onto it that has a query source showing all possible employee id's/names. Then make a query based on 'assigned responsible' which contains as a column the id or assigned name. Add criteria to the assigned name column and set it to point at the form's combo box ( eg = [myForm].[myComboBox].value ). All you need to do now is base a control's recordsource on that query (for example a listbox on that same form) , and add a button to requery the control. If you are a programmer, you could set the click event of the combo box to refresh the query (and of course there a lot of more complicated ways to do this, but this one results in less code)
Hope this helps
Andrew Fraser
by mahunsaker
by mahunsaker
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending