Can it be done??
As I like to push my knowledge of Access and VBA, I'm working on a database to track some stuff for a game that involves multiple pieces of information.
Here's what I've gotten so far:
- Select data from multiple tables and create a new table via query
- Using VBA, I then change the table name, based off of user input, and use that same name to create a new page on a tab control to match it.
Here's what I'm looking to do:
I have blank sub form titled "BlankForm", with no table assigned to it, that I would like to add to every newly created page and then be able to assign the newly created table as the data source for that sub form on the corresponding tab.
Is it possible to do or am I just dreaming?