Append if edit date is later than previous date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am opening a subform which basically writes to the same table as the form.
What I want is I have a field in the form called DtRecd and one in subform
called DtRej. If the DtRej is a date later than DtRecd then I want to append
a new record row to the Table and if its same date then I want to update the
fields in the same record.
Can it be done. Pls let me know if additional specific details would help in
addressing the question.
Thanks & Regards,
Abhijeet H. Desai
 
If [thisdate] > [ThatDate] Then
strQry = "qryUpdate"
Else
strQry = "qryAppend"
Endif

docmd.openquery strQry

or something like that.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Back
Top