Coaching Requested on Setting up a Form

[TAM]

I am new to Access and need to create a form with a subform. There will be a combo box linked to another file containing client IDs. When the client ID is selected, it needs to pull those record(s) for the client selected. I'm seeking to understand the following:


1) Is this a form with the combo box in the header?
2) How do I link the client ID from the header to the subform.
3) Is the data entry section in blue one subform and then I create a 2nd subform as a table? If so, how do I link all 3 client ID fields? or is it one form using a split form?

[ranman256]

The form is a single record view of 1 client.
The subform is linked to the master field CLIENT#, so you only see THAT master Client Id's records.

the combo is unbound in the header, in the afterUpdate event
the combo will filter the 1 clientID

sub cboFind_afterupdate()
    me.filter = "[client#] = " & cboFind
    me.filterOn = true
end sub

[TAM]

Thanks. I'm a novice and I'm building all of these forms using the wizard.

So, let me go through the steps based on what you have above:
1) Create a Form with an unbound field for the client ID.
2) Add a subform to get the table layout view
3) Add another subform to get the form layout view

in the Form, I will put the code you have which will filter on client ID. I'm still stuck on whether I need to create two subforms or one. If it's two, how do I link both subforms to the header input?

[June7]

Exactly what tables are involved?

Review
https://support.office.com/en-us/art...8-C266FE084102
http://www.allenbrowne.com/ser-62.html

If only one table then a single form set for Continuous view can be used. Data controls can be arranged to look like Datasheet. Filter controls in header section.

[TAM]

Exactly what tables are involved?

Review
https://support.office.com/en-us/art...8-C266FE084102
http://www.allenbrowne.com/ser-62.html

If only one table then a single form set for Continuous view can be used. Data controls can be arranged to look like Datasheet. Filter controls in header section.

Two tables:
Table #1: A unique list of IDs. This would be used for the combo box.
Table #2: A table which has multiple records per ID

[June7]

So which option do you want to try?

The single form approach would bind form to Table 2 with unbound combobox in header listing IDs from Table 1.

A form/subform approach would have main form bound to Table 1 with the unbound combobox in its header. Subform bound to Table 2 would be linked to main form. Only associated records will display in subform. Use code behind main form to find desired ID record.

[TAM]

So which option do you want to try?

The single form approach would bind form to Table 2 with unbound combobox in header listing IDs from Table 1.

A form/subform approach would have main form bound to Table 1 with the unbound combobox in its header. Subform bound to Table 2 would be linked to main form. Only associated records will display in subform. Use code behind main form to find desired ID record.

The form/sub form, please and using the Wizards. Thank you!

[June7]

And how did that go? I never use the Wizards.