enter date in a form to populate records in a query

M

mattsmom

I have one database to track the progression of inspection reports, there are
7 end users. The forms pop-up and the db is hidden. I created a form to
input records into 2 tables. The query (BatchQuery) pulls from the 2 tables.
The users will review hard copy inspection reports and then open another
form which displays data pertaining to these records and contains six text
boxes for date input. They will then input the date they complete their
review. I need help getting the date they input to populate all the records
in the query immediately, as they will then print a report.
I have been able to update/populate all the records using an update query,
however that is another step I will have to complete and the user will have
to wait for me to perform this action.
Oh, this database was created with 2003 and we have recently converted to
2007. I have been working to get this to work the ’07 version for about a
month. I have even started to create a new db in 2007. Someone – please
help me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top