🚀 go-pugleaf

Send me a draft of your database and I'll help you out.  It sounds simple,
but sometimes you have to see for yourself. But it sounds as if you need to
use the value of the combobox (the culture) as the criteria for a form you
want to open (displaying all fungacides that correspond with that culture).
But if you fire a docmd.openform method using the vaule of the combobox in
the where condition of that method, then you should be able to open that
form of all fungacides, filtered by the value in the combobox.  Let me know
if you need more help.  What do you do for a living?

Rob Calfee
trace@primenet.com
Digger wrote in message <903622704.361111@ciril.esoterica.pt>...
>How can I define a filter based on the user's choice in a combo box?
>The case is:
>I pretend to allow the user select one type of culture (in a ComboBox),
then
>click a button and display a form all the products (fungicides) used with
>that culture (one culture to many fungicides).
>
>Is it possible? I Use MS  Access97
>If someone could spend some time with this question, I'ld be very pleased.
>If necessary, I'll send by e-mail a draft of my database (about 30 kb...)
>
>

You could use the "recordsource" forms's propertie:

combobox afterupdate event:

   me.recordsource = "select * from table where
((table.field)=Forms![formname]![combofieldname])"
  me.requery