Automatically linking Form to New Table Part 2

[Webslinger1275]

I guess I should have asked the question first, huh?

How do I automatically link a Form to a Newly created table (possibly all within a macro)?

Sorry about the last posting, I'm new at this.....obviously.

Thank you in advance.
web

 

[Dalain]

Open the form in design mode then in the Form properties and under Recordsource enter the name of the table(click the down arrow, or click the three dots and create query.


if the form is in normal mode, you can create a table with the field called strRecSource (text type, 255) Enter the name of the table or the SQL statement in this field, then in the on open event of the form,

Me.RecordSource = DLookup("strRecSource", "TableName")

Hope this helps
Dalain