I have created a form in Microsoft Access. I am using a tab control in the form and have several tabs with each tab containing separate data. Now what I am trying to do is put a ''next'' button on each tab that will go on to the next tab with a ''submit'' button on the very last tab. I do not now how to create the ''next'' button that I want and it appears it is not as simple as using the create button wizard. Does anybody know how this could be done?
If it requires me to use Macros or VB code, can you assist with how?
Thanks!
Microsoft Access Help???nortonantivirus
yes, each tab has an page which you set focus on using the page index property. Turn the wizard off then create the button . In the properties tag, got to events and select the ON CLICK event. Go to Code builder and then type the following between the Sub and End Sub coomands
dim indexfortab=1 'this should be the next tab number in the sequence
Me.TabCtl0.Pages(indexfortab).SetFocus
any problems then email info@bitsysuk.com....we do software!
Microsoft Access Help???spyware
You already have been given 2 good solutions, but if you are overwhelmed, I have an easy solution for a beginner...It is ineffiecient but it will get the job done. Make a macro for each tab you want to move to. First, to to your form and find the ''Name'' of each tab in it's properties.
No comments:
Post a Comment