How do I select a record and if no record exists go to a new recor

How do I select a record and if no record exists go to a new recor

Post by SlBHZW9yZ2 » Fri, 11 Nov 2005 15:06:02


(Newbie request)

I have defined a table where IDNumber is Indexed (Dups OK) and ReportDate is
not indexed, but I want to create a query that returns the other data based
on these fields and updates the form. If there is no record for that
IDNumber and ReportDate, I want it to select a new record to update.

Thanks in advance.
JPGeorge
 
 
 

How do I select a record and if no record exists go to a new recor

Post by [MVP] S.Cl » Sat, 12 Nov 2005 02:48:09

You're question is too ambiguous. Please post the table structure.

Also, what on the form is being updated? A field or the underlying data in
it's recordsource?

--
Steve Clark, Access MVP
http://www.yqcomputer.com/
*FREE* Access Tips: http://www.yqcomputer.com/