UtterAccess Discussion Forums
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.
Aug 14 2005, 04:33 AM
if nz(dlookup("DateField","Tablename","DateField=#" & me.ControlWithDate "#")) =DateValue(me.ControlWithDate) then
msgbox "Date is in recordset",,"Note"
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please