Using multiple tables in a tab control

[jonobugs]

Is it possible to use multiple tables in a tab control?

I don't mean using inserting subforms, but rather a different table entirely.

For example, I have a form where you can enter in Student information, and I want to put Class information on a tab form so that the user can quickly tab over to add in a new class if needed. I found a posting that shows how to enter in information without going to a new form, but since the class table has several pieces of information (time/days/name, etc) I think it's best to just jump to a new form. However to make it smoother, I want to be able to use a tab control to just change the form quickly and then pop back to the record again.

 

[Minty]

A sub-form can be an unlinked / unrelated form on a an unrelated table.

 

[plog]

No. Check out the Data Properties for a tab control--it doesn't let you define a control source. You use the one associated with the form.

I would advise an unlinked subform based on whatever table you want to interact with. Don't know why you are against this.

Also, if you simply wanted to insert data into a 2nd table you could use unbound controls on a tab to do so. Let the user enter data into them and have a button when clicked it performs an INSERT into the appropriate table.

 

[jdraw]

How about popup modal form to add info on that separate table. Fill in the form, update the table and close the popup.
Just a thought for consideration.