Multiple items subform showing records selected in main form

[RuralGuy]

Have you tried pointing to one of your ComboBoxes for the LinkMasterField yet?

[schwabe]

Hi,

thanks again for your reply. Maybe, I didn't point out properly, where my problem is now.

I've started basically from scratch, in order to get your approach straight.

I set up the main form bound to the query qryProjects and it's got the fields IDProject, txtProjectName, lnkCustomer, txtCustomerName.

Then I have two subforms, but as they assess the same data, we can simplify the problem to one subform. (The subforms do not interact).

The subform sformTimeLine lists the delivery dates for each project and is bound to a query qryTimeLine with the fields:
datDueDate, intNoBoards, lnkProject, lnkCustomer.

I've set up the following two links:
Link Master Fields: IDProject; lnkCustomer
Link Chield Fields: lnkProject; lnkCustomer

Presently, I just have two textboxes in the mainform indicating txtProjectName and txtCustomerName for each record. The subfield shows the proper events for each record set. So, the link should be okay.

However, I have to switch between the projects, so the records of the main form, by using the navigation at the bottom. This, I would like to change.

Instead, I'd like to put a ComboBox in the main form which lets me choose the project. When I simply replace the textfield by a ComboBox, Access shows the project Name, but doesn't let me change the value of the box. It gives: "Control can't be edited; it's bound to AutoNumber field "IDProject".

[schwabe]

Hello,

I've solved that problem, by removing the Control Source of the ComboBox and changing the Master Link fields. Thanks again for your support.

[RuralGuy]

Outstanding! Thanks for posting back with your success and solution.