I'm sure this has been answered before here, but I've read about a zillion posts and can't find the answer. So here goes...
I have a form based on a query. The way it works now is the query asks for a parameter(Project Manager) and when the form is opened the little [Enter Project Manager] box pops up and you can type in the info and the form comes up. That works fine...
What I want to do is replace this box with a combo box, which will have a list of the project managers so the user can select one of them, and then it will pass this to the query. I've read that I should create a popup form, and insert an unbound combo box that has the info i need, and then enter the link to the combo box[forms.formname.controlname] in the query as criteria.
I'm not sure what I do after this. Am i going about this in the correct way? Any help or nudges in the right direction would be most appreciated.
Thanks
Ted
I have a form based on a query. The way it works now is the query asks for a parameter(Project Manager) and when the form is opened the little [Enter Project Manager] box pops up and you can type in the info and the form comes up. That works fine...
What I want to do is replace this box with a combo box, which will have a list of the project managers so the user can select one of them, and then it will pass this to the query. I've read that I should create a popup form, and insert an unbound combo box that has the info i need, and then enter the link to the combo box[forms.formname.controlname] in the query as criteria.
I'm not sure what I do after this. Am i going about this in the correct way? Any help or nudges in the right direction would be most appreciated.
Thanks
Ted
