Choosing what's displayed in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Stuck on this one (probably simple) thing, and am hoping someone out there
can give me a push so I can continue on.. Here's the scenario..

Would like to open a form and have a pop up ask for criteria. The criteria
is listed in a table. Would like to be able to choose the criteria from a
drop down. Then when the form opens, would like that criteria posted on the
top of the form as flat text..

Told you it was simple :) Thanks in advance for any help..
 
Why have a pop up? Just include a combobox in your form's header. If you
are trying to use that box to select which record displays, then the
combo-box wizard will walk you right through the steps.

If that is not waht you have in mind, then I must have misunderstood you.
 
katie67 said:
Stuck on this one (probably simple) thing, and am hoping someone out there
can give me a push so I can continue on.. Here's the scenario..

Would like to open a form and have a pop up ask for criteria. The criteria
is listed in a table. Would like to be able to choose the criteria from a
drop down. Then when the form opens, would like that criteria posted on the
top of the form as flat text..

Told you it was simple :) Thanks in advance for any help..
Click to expand...

I suggest you just open the form initially filtered to a null set (Where 1 = 0
or similar). The just add your ComboBox to the top of the form in the header
and use its AfterUpdate event to apply a new filter to the form.
 
I agree with Rick, what if the user made a mistake choosing the criteria.
add a combo to the main form, listing all the criterias, after the user
select 1 it will refresh your form.
the combo can be used as the header you wanted, and you can link the
recordsource of the form to your combo.
 
Back
Top