Forum Discussion
New to access trying to print a car's specific info to a form and report
Access provides a really good mechanism for requirements of this sort.
Use a main form/sub form design.
The main form is bound to the Customer table.
The sub form embedded in that main form is bound to the automobile table.
The subform control (in which the automobile form is embedded) has a property that controls which records from the automobile table appear in the subform, the
Master Linking FieldLink Master Fields and theChild Linking FieldLink Child Fields properties. This means that the automobiles displayed in the subform will be only those where the CustomerID is the same as the CustomerID for the currently selected record in the main form.Because the subform can be displayed in Continuous view, ALL of the current customer's vehicles are displayed in full and you can select the one you want.
A similar mechanism is available for reports/subreports.
Access provides a really good mechanism for requirements of this sort.
Use a main form/sub form design.
The main form is bound to the Customer table.
The sub form embedded in that main form is bound to the automobile table.
The subform control (in which the automobile form is embedded) has a property that controls which records from the automobile table appear in the subform, the Master Linking Field Link Master Fields and the Child Linking Field Link Child Fields properties. This means that the automobiles displayed in the subform will be only those where the CustomerID is the same as the CustomerID for the currently selected record in the main form.
Because the subform can be displayed in Continuous view, ALL of the current customer's vehicles are displayed in full and you can select the one you want.
A similar mechanism is available for reports/subreports.
George_Hepworth Thank you so much sir, the idea of adding a continuous form as a subform works perfectly. Thank you very much I'm very happy.
George_Hepworth Thank you and I'm sorry for the late reply as I had to get something working for them quickly, so I improvised until I could learn a more efficient process which I believe you have provided. I'll give it a try today and get back with you. Thank you again so much for your help. Best Regards, Tony.
