Subform link to Master table

[sara_in_ga]

Help -

I have two tables. One is called tblMaster and contains information about
projects that are project specific such as Project ID, Manager, Vehicle Code,
Customer, etc. The other table is called tblProjects and has all the data
for each project. The only field that is different with each input is the
field called OpenIssues. What I am trying to do is create a sub form view
where the end user can select the project number and it will populate all the
data in the form from the tblMaster. Then on the form the end user can
update the project status.

I have created the form but have two issues.

1) I don't know how to set the ProjectID field to be choseable and the other
fields to fill in correctly.
2) My subform which contains OpenIssues only show the first item and no
others.

Any help would be appreciated.

Thanks,
Sara

 

[Joan Wild]

If you have a relationship set between the two tables, the form wizard will create the form/subform for you.

When you run the wizard, at step two choose all the fields from tblMaster, and then select tblProjects and all its fields before going to step three. Access will give you the choice of a form/subform or a form with a button to open a second form.

When the form/subform is created, add a combobox to the main form. Again the control wizard will give you the option of 'finding a record on my form based on the selection'.