filter by form issue...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I have a subform where all fields are bound to a recordsource which happens
to be a query - pulling three tablkes together. When the user clicks the
"filter by form" button, in each field there is a drop down giving them only
two options - "Is Null" and "Is Not Null". For some of the fields I would
like to allow them to be able to select values for that field from a drop
down - such as in a combo box which is linked to another table to get it;s
values). An example is Customer Name. Right now they would have to type that
name in. However, I would like them, to be able to select the name from the
customers table instead.

How can one provide this functionality using the built-in "filter by form'
tool?

Thanks,

Brad
How does one do this?
 
Hi,


Use a combo box? Put the list of customers in the rowSource (through a
query, or the table with the customers). In the after update event of the
combo box, do as you do now, with the edit box.



Hoping it may help,
Vanderghast, Access MVP
 
Tools - Options - Edit/Find

This behavior is regulated by the entry "Don't display lists when more than
this number of records read."
I think the idea is to avoid the time it takes to prepare all of those lists
when there are lots of records (and presumably many fields are not indexed.)
But you might want to try increasing that number, so it is greater than the
number of records in your form's recordset.

HTH
- Turtle
 
Back
Top