Tab adds new record

[xionhack]

Hello. I'm new at this. I'm using Access 2010. I'm creating a form, where I would have a tab control with data from a related table. Is there any way, to have something like a "plus" button or something like that in the tab, that every time i press it, it will open a new tab and start a new record in a related table? Thanks

 

[JamesMcS]

Like tabbed browsing on the web? You can't add a new tab in form view, so what you'd need to do is create the maximum number of tabs you'd need and hide the ones you don't want to see. Then, as the user clicks on the next tab, unhide the next one, and so on.

 

[xionhack]

For example, I have 2 tables, a "school" table and a "professors" table. I want to be able to type all the information of that "school" in the form, and then have a tab control under the school information where I can type the professors information, then maybe when I click on a new tab or in a plus sign or something like that, another tab will open with new record to type a new professor. This is just an example. Thank you!

 

[JamesMcS]

You might be better off using a subform for that. As I say, you can't just create tabs in form view, they'd need to exist already and you'd have to programatically unhide them as you go along.