B
BettyBoop0024 via AccessMonster.com
Hello, I already found the informantion on the site and was able to make a
popup form with a combo box to select a company name from a query that opens
a report when I click a OK command button. The report runs from a macro on
the form. Everything works very good.
What I would like to do, if it can be done is to add another sort option.
The field that I would like to sort is a date field, and there would be three
criteria options:
First would be to pull all records with a Null field, Second "Is Not Null"
and the Third would all records.
I thought about an option group but you can only enter numbers. So I was
thinking of another combo but I'm not sure if I need another macro or could I
just reference the query from the form and combo.
Any help and guidance would be appreciated.
popup form with a combo box to select a company name from a query that opens
a report when I click a OK command button. The report runs from a macro on
the form. Everything works very good.
What I would like to do, if it can be done is to add another sort option.
The field that I would like to sort is a date field, and there would be three
criteria options:
First would be to pull all records with a Null field, Second "Is Not Null"
and the Third would all records.
I thought about an option group but you can only enter numbers. So I was
thinking of another combo but I'm not sure if I need another macro or could I
just reference the query from the form and combo.
Any help and guidance would be appreciated.