Thanks in advance!
Could someone please give me an example of using Dlookup to find a record and then update it. I can find the record by the following:
type1ans = DLookup("[TypeID]", "[tblEquip]", "[EquipType]= [cmbEquip]")
How do I update the fields called [Completed] (Y/N) and [DateCompleted]in [tblEqip] where type1ans equals the record ID. I am submitting all of this with a command button.
Thanks,
Lee

Rather than using DLookup(), create an update query that takes a parameter to supply the equipment type.

Da!
Sometimes I sit here so long I go totally brain dead!
Thanks Pat for the kick to get back on track!