Dynamic form record source??
Posted on 2002-07-22
Okay, here's what I've got. I'm working on a project where I have about 18 different types of tables. I need these to stay empty because they are my templates. I have a form that has an associated button for each type of table, and when you click it it prompts you to enter a new table name. This occurs through a simple macro. And after they specify the new table name I want it to open up a data entry form that I have built, specific to each type of table, but I need it to be associated with the brand new table that was just created.
Now, I'm almost posative that I'm gonna have to dump the whole simple macro Idea, and use some Event procedures (I'd really prefer to try and keep it on this level, because I'm a completely ignorant as far as VB goes)
How can I go about making it open up my Data entry form with it's record source being for the table that was just created?
please help me
thanks in advance