Filter on Open

  • Thread starter Thread starter Colleen
  • Start date Start date
C

Colleen

I have a form that is based on a table rather than a
query. I had to do it that way to have my combo boxes
work.

However; I want to be able to filter my form to only show
records that are active. My problem is the field is a
text field and I need to show either "LT" or null. Anyone
have any ideas.

Thanks.
 
With few exceptions, if you've used a table as a recordsource for your form,
you can use a query in place of that table....and that query can be as
simple as selecting all fields and all records from the table (essentially,
duplicating the use of the table as the recordsource).

Not sure why you would need to use table and not a query in order that your
combo box can work. If you can provide more info and details, perhaps we can
help you.
 
I have a form that is based on a table rather than a
query. I had to do it that way to have my combo boxes
work.
Click to expand...

Ummmm...

Wrong. Combo boxes work fine; the Recordsource of a form can be either
a Table or (much more often) a Query, but the combo boxes should work
equally well in either case.

What specific problem were you having with your combos? What were the
Control Source and Rowsource properties of the combos?
However; I want to be able to filter my form to only show
records that are active. My problem is the field is a
text field and I need to show either "LT" or null. Anyone
have any ideas.
Click to expand...

Base the Form on a Query with a criterion of

="LT" OR IS NULL

on the field, or use this same expression as a form filter.
 
I have tried changing it back to the query and NOW it
seems to be OK. I don't remember why it didn't work
before. I'm going to test it for a few days and see if it
is really OK. Thanks for your help.
 
Back
Top