Form Question

[jamesormi]

Hi,

I'm looking to create a form for a table that has a number of jobs on it. The table has an autonumber primary key as well as a job date. I would like to be able to view/edit/add the jobs on the form for only a selected date.

How do I go about this?

Thanks in advance.

 

[CEH]

You will have a query built from the "Jobs" table.... To show you a simple way.. In the "Date" field under criteria insert "Between [Beginning Date] and [Ending Date]" without the quotes.... That will show you how it works.... you can later reference an unbound form field if you like to enter your dates.

 

[DrSnuggles]

You could try this:

Add a combo box, the record source being the a distinct query of the dates form this table.

Then on Change Event of the combo box try this:

Dim strFilter As String

'Check value is selected.
'Write code here

'Apply filter

strFilter = FilterString(Me.comboxDate)
DoCmd.ApplyFilter , strFilter
Me.Requery