I have a Navigation form containing 4 sub-forms. Each of the sub-forms has command buttons on them. This includes Next Record, Prior Record, First Record, Last Record, Find Record, Deleted Record and Close form. Initially when I had each form come up individually I had to put all the buttons on each form. Now that I am attempting to use a Navigation form I would like to pull them off the form and put them above the sub-form (but still on the Navigation form) and have them apply to each sub-form that appears. When I try to attach a macro to a button I cannot get it to behave the way I want it to, i.e. go to next record, go to last record, delete record etc.
I know the answer is staring me in the face, but apparently I am blind in one eye and cannot see out of the other.
My db is to track my wood-turning items (in this case pen kits). Below is a pseudo drawing of the navigation form.
__________________________________________________ ___________________________
{form header} Pen Kits Support Data {detail} Next Record First Record Last Record Add Record Delete Record Prior Record Close Form Find Record Bushings Form Sub Form Drill Bits Form Maker Form Pen Finish Form {form footer}
__________________________________________________ _____________________