open a table from msg box

[mike02]

hey, i currently have this as my code aafter i successfully import the data:

MsgBox "Successfully Imported",

How can i set it up to have a button which opens a table. the table is selected from the combo box (cbotblname) thanks in advance.

I know you should open tables, but i want to because these are feeder tables into append queries, so i have to veiw them before. thanks,

[JoeM]

To get the VBA code to open a table, you can create a Macro that does one (using the "OpenTable" command).
Fill out the appropriate arguments (there are descriptions, and you can press F1 for more help).
You can then save this Macro and convert it to Visual Basic code by clicking on the "Convert Macros to Visual Basic" button on the Visual Basic menu/ribbon.
This will show you the code you need, and you can replace any of the arguments with variables (i.e. to make the table name dynamic based on a value in your combo box).

[mike02]

I know how to open a table from vba, what my question is using the msg box command can you add a button to it which opens a table? thanks

[JoeM]

I don't think you can add a button to your message box, but you can tell it what to do depending on what they click (yes/no/cancel).
If you want to customize something with special buttons, you will probably need to create your own Form.

[mike02]

ok thanks for letting me know!!!