Update yes/no field based on table

[ohmbru]

I am trying to make a check box update to "Yes" on my form [frmCHECKLIST]if the [Name] is in a table ([tblTRAINEE]). I'm using the AfterUpdate event. The form is not based on [tblTRAINEE]. [tblTRAINEE] is a simple list of names that is not related to any other part of the database.

Thanks,

Brian

 

[braindead2]

check out the dlookup() function
something like this

if dlookup("name","tabltrainee","name = '" & forms!fromchecklist!name & "'" = "" then
me.checkboxname = 0
else
me.checkboxname = -1
end if