Hi Mohammed ,

Customizing Master/Child fields is also very easy and can be done from within the Combo Box that you have.

For example, if your combo box is built from a value list with a rowsource similar to:

"InspectionF";"Inspections";"SamplingF";"Lab Sampling"

Just add 1 or 2 more hidden columns to the value list. These would hold the name of the Link Master Field and Link Child Field field name(s) so it might look like:

"InspectionF";"Inspections";"InspectionID";"SamplingF";"Lab Sampling";"SamplingID" --- if both forms use the same field name
With column count of 3 and widths like: 0;1;0
-- or --
"InspectionF";"Inspections";"ProductInspectionID";"InspectionID";"SamplingF";"Lab Sampling";"ProductSamplingID";"SamplingID" --- if different field names are used
With column count of 4 and widths like: 0;1;0;0

Then your combobox after update event would include something like:

SubFormName.SourceObject = ComboBoxName.Column(0)
SubFormName.LinkMasterFields = ComboBoxName.Column(2)
SubFormName.LinkChildFields = ComboBoxName.Column(2)

If the field names are different between the master and child forms, change the LinkChildFields to ComboBoxName.Column(3)

Thanks a lot Mr. Blackwell I appreciate your reply it was helpful and I could use it to build my dynamic sub form thanks a lot

Looks like you got a good solution working - glad to hear it, and thanks to Donald for laying out that approach. The key trick here is storing the form name and both link field names in your combo box's Row Source, so when you switch forms, you can dynamically set both the SourceObject and the link master/child fields in code. This scales well even if you add more subform types later - just add additional rows to your combo's value list, keeping the master/child link info for each. As your app grows, you might want to move this info to a table instead of a value list for easier maintenance. Keep making regular backups as you experiment with the design - Access can get a little cranky with dynamic forms sometimes.