Opening a table

[lloyd5v5]

Is it possible to open an individual table automatically when you open the access file, I know you can do it for a form.
lloyd5v5

[NTC]

yes there is an Open Table command but it is not a choice in the feature set of the db options like they offer for forms....

create a macro to do it and name it: AutoExec

in creating the macro select 'All Actions' up in the ribbon and then in the first and only line enter: OpenTable
the next line below it will offer you a drop down to select your table
save and close db - will run when db opens.

[lloyd5v5]

yes there is an Open Table command but it is not a choice in the feature set of the db options like they offer for forms....

create a macro to do it and name it: AutoExec

in creating the macro select 'All Actions' up in the ribbon and then in the first and only line enter: OpenTable
the next line below it will offer you a drop down to select your table
save and close db - will run when db opens.

Sorry, senior moment...... I have created a macro and it now does what I wanted. Thanks