Help please: dates in combo box to bring up event or item

[Bob H]

I have designed a simple tool inventory for my work, and wish to modify
it now.

I have a table which has a list of given tools and some which need
testing in or on any given future date.
I added a form called frmToolssearch, with the Due Test Date as the
search criteria in the combo wizard setup. The Due Test Date was field
selected for the combo box.

So what I want to do is to select any date from the combo box, and that
date will show or bring up the relevant tool which needs testing.

I hope it is clear enough to understand, but maybe I am going about what
I want to achieve in the wrong way.

Thanks

 

[tina]

you can use the combo box control to restrict the form records in a couple
ways. first, the combo box control should be unbound, that is, it's
ControlSource property should be blank. 1) you can use a query for the
form's RecordSource, and set query criteria on the date field, as
Forms!frmToolssearch!ComboboxControlName. or 2) you can use VBA code to set
the form's filter from either the combobox control's AfterUpdate event, or
from a command button, as

Me!Filter = "[Due Test Date] = #" _
& Me!ComboboxControlName & "#"
Me!FilterOn = True

in either scenario, replace ComboboxControlName with the correct name of the
control.

hth