DoCmd.OpenTable help.

[magmike]

I am having problems with my OpenTable code. (Sorry, I'm new at this)

DoCmd.OpenTable Potential_Produ cts_Presented

The debugger says I need a table name.

This code is in the Dbl Click event of a form field. Thanks.

[fredg]

Re: DoCmd.OpenTable help.

On Mon, 06 Aug 2007 08:47:52 -0700, magmike wrote:

I am having problems with my OpenTable code. (Sorry, I'm new at this)
>
DoCmd.OpenTable Potential_Produ cts_Presented
>
The debugger says I need a table name.
>
This code is in the Dbl Click event of a form field. Thanks.

The name must be a string value, so enclose the name within quotes.

DoCmd.OpenTable "Potential_Prod ucts_Presented"

By the way, tables are for storing data, and should not normally be
viewed. It's best to use a form to view your data.

Because forms have events, you can manipulate your records, enter new
records or edit existing ones, and still have some means of assuring
the data is properly entered.

Create a form based upon your existing table.
Then:
DoCmd.OpenForm "Potential_Prod ucts_Presented" , acFormDS
will open your form in datasheet view.


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail