Adodc

[GlenW]

Sorry, slight mistake.
Use Refresh there is no Update.

[rattack]

Leather,
Now the error comes up saying microsoft jet cannot find input table or query "tablename".??

[Leather]

Ok the so it looks like you are trying to run aa query like

"SELECT * FROM TABLENAME"

You need to append the table name.


IE

"SELECT * FROM " & Text1.text

Or

"SELECT * FROM " & listbox1.text

In other words you must put the actual table name into the SQL statement.

[rattack]

Here is what I have

Private Sub Command4_Click()
datPrimaryRS.RecordSource = "select* Name,Car,Origin,[Round 1 Time],[Round 1 Speed],[Round 2 Time],[Round 2 Speed],[Round 3 Time],[Round 3 Speed],Position,[Nominated Speed],Variation from [Class IV] "

datPrimaryRS.Refresh
grdDataGrid.Refresh

I copied most from current record source.maybe i have it all back to front.

[Leather]

U need a space between the SELECT and the *

[rattack]

This must be very frustrating for you and i apologise.I now have another error.

Syntax error (missing operator) in query expression'*name'

[Leather]

Hey thats ok, no problem.

Its the same for everyone.

Delete the * altogether..

Sorry should have spotted that straight away..

Let me know if that works.

[Leather]

The * in a SQL Statement is used to retrieve all columns in the table or view... If you intend to specify column names (as you have) then tehre is no need for the Asterix.

[rattack]

leather you are a genius.Thankyou very much for taking the time to help me it is greatly appreciated.
I owe you one.

[Leather]

No Problem m8...