UtterAccess Discussion Forums > Recordset testing

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

Golfnutt

Aug 14 2005, 04:15 AM

I would like to test for the possiblity that a date for a recordset has already been entered and if it has, output a yes/no message box.

Hope this is clear, thx.

strive4peace

Aug 14 2005, 04:33 AM

CODE

if nz(dlookup("DateField","Tablename","DateField=#" & me.ControlWithDate "#")) =DateValue(me.ControlWithDate) then
msgbox "Date is in recordset",,"Note"
end if

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.