I am experimenting with a database layout, where everything is accessed via one form. Within that form, is a Tab Control. On each page of the Tab Control will house a different form.

I would like to create a set of navigation buttons in the main form's footer, that will control the navigation of which ever form is visible at that time.

Eg if the form on Page One is visible/Page One of the Tab control is active, the naviagtion buttons will cylce through the records of that form. If the form on Page Two/Page Two of the Tab control is active, the navigation buttons will cycle through the records of that form etc.

Can any one offer any help, on how I can capture the form name that is on the visible Page of the tab control and pass it back to the Navigation button code to process the require code execution.

I have attached a sample of my trial database for anyone to look at.

Thanks in advance for any help.