Change the Sub-Form View by using VBA

[caliandro]

If you have to make a comment for each tag you record, then a multi-select combo will be no help to you.

@Pat Hartman
Dear Pat. The relation between comments and tagnumbers is 1 to many. One comment to many tagnumbers.
I cannot publish the supplier document for legal reason but image the comment is for example: "painting color RAL should be RAL1731" and this comment is applied to all the tags listed in the page where the comment is inserted.
@Gasman
Dear Gasman, thank you for your instruction, I will prepare a sample of the mask for the data entry of the tagnumbers and then I will post the photo.

 

[Uncle Gizmo]

now add a Tab Control on your form with 2 tabs and put the subforms on their respective tab.
then add a Command button on the form that serve as a switch between form views of your
subform. You can Hide the Tabs on the Property of the Tab Control.

Further to ArnelGP's excellent suggestion, it's often a good practice to set the Record Source of subforms to nothing if they're not actively displaying information. By only assigning the Record Source when you open the tab containing the subform, you can significantly improve performance, especially when dealing with large datasets.

You can check out a method I use to achieve this in the video linked here:-

72 Fields on a MsAccess 2007 form

to separate comparison data for each group, but have now changed the layout to 5 Tabs on the sub form to analyze / display similar data groups. I hope to import the data from our Excel Spreadsheets Think about your data. It sounds like you don't want tables that mimic the spreadsheets. You...

www.access-programmers.co.uk