Still having combo box problems in place of parameter box

  • Thread starter Thread starter taf
  • Start date Start date
T

taf

OK--

So, I am trying to use a combo box (drop down list) in place of a
parameter text box to generate a report that is bound to a select
query. I have the query built, the form in place, but when I click on
my OK button on my form after I have selected the value from the drop
down, I am still prompted by a parameter dialog box. Any ideas where I
have gone wrong?

Thanks so much to anyone who can help!!!
 
Hi,
did you reference the combobox correctly in the query field criteria:

[Forms]![YourForm]![YourCombo]

Also make sure that the values to be used are in the default key column of
the combo or you will need to reference the correct column to be used.
HTH
Good luck
 
Freakazeud - two questions:
1 - For my query input form I am using a combination of cbo and txt boxes.
How can I verify the default key column for these objects is what I need?

2 - I am hoping to have the query input form contain a field for many
parameters, not all of which would be used in every query run. How do I code
the query to accept null entries from the form? I've tried the following:
[Forms]![frmQryMain]![tbxRespDiv] or [Forms]![frmQryMain]![tbxRespDiv] Is Null

but still receive user prompts to input parameters.

Thanks,


freakazeud said:
Hi,
did you reference the combobox correctly in the query field criteria:

[Forms]![YourForm]![YourCombo]

Also make sure that the values to be used are in the default key column of
the combo or you will need to reference the correct column to be used.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
http://www.oli-s.de


taf said:
OK--

So, I am trying to use a combo box (drop down list) in place of a
parameter text box to generate a report that is bound to a select
query. I have the query built, the form in place, but when I click on
my OK button on my form after I have selected the value from the drop
down, I am still prompted by a parameter dialog box. Any ideas where I
have gone wrong?

Thanks so much to anyone who can help!!!
Click to expand...
Click to expand...
 
Back
Top