Create a form/subform in Access 2007 that displays multiple records to be updated.

15 pts.
Tags:
Access 2007 forms
I have an Access 2007 database that has 2 tables:  1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at.  2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork returned.  I need to create a form that lists all of the employees at a selected location that uses all of the dates for a given month as column headers.  Under each column header that corresponds with a date the employee worked, I would like to have 2 check boxes for paperwork received and paperwork returned that can be edited so that those 2 values can be updated in the Work Log table.  Is this possible and if so, how can I accomplish this?  I am relatively new to Access.

Software/Hardware used:
Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

Tried changing design so that all controls on first tab were part of main form rather than subform. Changed all subform recordsets so that they don’t include the PK in the query, but link only through the master/child properties

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Genderhayes
    Creates a new form and subform combination by using the Form Wizard In the Tables/Queries drop-down list, select a table or query Double click the fields that you want to include from this table or query Double-click the fields that you want to include from this table or query Double-click the fields that you want to include from this table or query If the wizard does not ask How do you want to view your data?, that means that Access did not detect a one-to-many relationship between the tables or queries that you selected. The wizard will continue, but Access will not add a subform to the form.
    7,485 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following