Combobox value transfer to another frm text box.

[John Big Booty]

This is an extreme guess; I suspect that you could test the OpenArgs in the form's On Load event and use the result to set the form's RecordSource to the appropriate query.

 

[november]

This is an extreme guess; I suspect that you could test the OpenArgs in the form's On Load event and use the result to set the form's RecordSource to the appropriate query.

I figured out how to not have to use multiple queries by just changing the variables via buttons.

I have an issue with that though. If I run the query without the form loading the value I get prompted and I cannot leave it blank or use * as a wildcard because it returns no results.

Is there a way can utilize a wildcard for this? If not, I was thinking I may have to hardcode all the PM's into a variable.

 

[John Big Booty]

If the query has been designed to be run from a form that is feeding it criteria, why do you want to run it without the form?

 

[november]

If the query has been designed to be run from a form that is feeding it criteria, why do you want to run it without the form?

To test it out and go to it quickly.

but once the form is visible with the data I have buttons that I want to switch between the "items" and their "parts".

So I'll need to use a var to populate criteria for the division(items or parts) and then requery to show the values.

Make sense?

 

[John Big Booty]

Could you not enter a value in the dialogue box that you know would return a result?

 

[november]

I can but for one display I want to view a the people that fall under the director.