Updating Table Columns from a form

[gaus]

Hi,
It appears Access2000 may be different than 97. In one of my 97 DB's I had a text box updating a column via the format:
[TABLENAME].[COLUMNNAME] = Forms!FormName!txtTextBox.text

When I try that in 2000, it tells me it cannot find the object
TABLENAME

Ideas?
Thanks,
Gary

 

[Steve101]

Gary,

Its difficult to tell the exact context of your problem based on the detail provided, but its possible that if you are referring to a recordset from within code, then you want to be using a ! instead of a . (dot); ie:

TABLENAME!COLUMNNAME = Forms!FormName!txtTextBox.text

The earlier versions of Access were more forgiving. Remember that you use a dot to designate a property or method of an object. You use a ! (bang) to designate an object (within an object).

Not sure if this is the exact cause of your problem though. You may have to provide further context.


Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[gaus]

I'll check it out - thanks!