I have a form with 2 sections.  One where the user is able to submit a new
record to a table and the other where the user is able Query all records in
the table by date and pull up repeating records with the same date.

When the user queries the table, the first record  in the repeating section
of the query on the form is also displayed in the submit section.  As the
user continues to query different dates, the date fiield in table changes to
reflect what was queried in Access database.

Also, the user is then able to change the information from the query because
it is displayed in the submit section where the user creates a new records.

I tried creating a secondary table and creating a query from that, but it
doesn't populate.

Any suggestions?