Submit and query to same Access table problems

[aerobar2]

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?

 

[Adam Harding]

Hi

essential the submit section of the form shows the same data as the first
searched field as they are datafields and any query OR submission puts its
results in a query field.

Personally i would proably put the search on another view, and give them a
button to switch between views on both views.

On the query view the button would switch the view and clear all the fields,
on the submit view it would switch to the query view.

Make all the fields in the query view read-only and you are there.

Any problems give me a shout.

Cheers Adam

 

[aerobar2]

Ok, I'll give this a try. It sounds like it will work. Thanks, Beth