Automatically linking Form to New Table

[Webslinger1275]

I'm using Access '97.

Within a macro I create a new table (using make-table query), then I rename the new table. After which, I would like to automatically link my form to this newly created table.

Thanks,

 

[PHV]

Something like this ?
Me.RecordSource = "Name of table"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244