Combo Box items filtering (in datasheet)

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Does the filter work correctly. If the filter is an SQL
string in the filter property of your form, copy that text
to a query in the the Query builder. Run the query. Make
sure if your filter is based on some value in a field on a
form (any form) that the form is open and a record is
selected in the appropriate field. If the query runs
correctly, I am not sure what the problem might be. If
not, get the query running correctly, then copy the text
back to the filter.

Hope this helps!

Kevin
 
I have a form where user can enter information to filter
out unwanted items in the combo box. There is a sub-form,
in this form, with column (that references to other table)
and afore-mentioned combo box is used to edit this column.
I don't filter information in the sub-form I filter
information in the combo box. But items that were left out
from combo box do not displayed in the sub-form.

For example sub-form contains 3 records and they have
next data in discussed column {a, d, e}. User chooses to
filter out all items that begins with 'a'. Combo box will
contain next items {d, e}. Sub form will look like:

1) <- a must be displayed but blank space appears instead
2) d
3) e

I think form uses combo-box data to display information
in its rows, and if data is not presented in the combo-box
nothing will be displayed in a row.
I could use extra dialog-form to edit rows but I think
it isn't very convenient.

Sorry guys but I am not a native speaker and may be my
English isn't good enough to explain everything clearly.
If you wouldn't understand something please do ask.

Thank you for your help!
 
Back
Top