Forms

[Froto]

How would I need to code a command button to search my
database for records that have certain fields filled in.
I need to search by present date. So only records with
certain values that were submitted on present date.

Thanks in Advance.

 

[John Vinson]

How would I need to code a command button to search my
database for records that have certain fields filled in.
I need to search by present date. So only records with
certain values that were submitted on present date.

Thanks in Advance.

A Command Button? Why not a Query? (You can open a query using a
command button, but it's the query which searches the database).

Create a Query based on your Table. Select the fields that you want to
see. On the Criteria line under the date field put

=Date()

to select those records where the datefield contains today's date.