Make a field in a form display a certain value

[dahl0000]

I collect records from multiple counites and I need a way to see what the last record from each county was collected on a form. I created a query called LastRecord and put a Top Value Rule of 1. I then created a form based on the query. In that form I want a field to show the last record and date collected for a particular county. I will be having multiple fields for many different counties on that form. Can I filter the query by using the control source in the field? Or how can I change the criteria of the query for each field?



Thank you

Kris

[ranman256]

filter records with a combo box

private cboBox_Afterupdate()
if isNull(cboBox) then
   me.filterOn = false
else
   me.filter = "[field]='" & cboBox & "'"     'view only this county
   me.filterOn = true
endif

or load the record based on the last record (largest Index)

private cboBox_Afterupdate()
dim vID
if isNull(cboBox) then
   me.filterOn = false
else
   vID = dMAx("[ID]","qsQryOfItems","[County]='" & cboBox & "'")   'get the last record
   me.filter = "[RecID]=" & vID
   me.filterOn = true
endif

[dahl0000]

Thank you!