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.