update 2000 to 2003 macro help

[Gerry H]

Hi,

I have just converted a 2000 database to 2003 and now my macros dont work.
They should be quite simple and are for setting up OK and Cancel buttons on a
form to populate a query.

The error i get is related to the Action "SetValue" (when OK is pressed),
previously the parameters were Item - Visible and Expression - yes

The error I now get is that the expression is invalid.

Any help would be apreciated.

 

[Jeanette Cunningham]

Hi Gerry,

here is an example from A2003 help. You may need to create a new macro in
A2003.
This example is used to set the SupplierID control to the current supplier
on the Suppliers form.

Action is SetValue
Item: [Forms]![Products]![SupplierID]
Expression: SupplierID

Jeanette Cunningham

 

[Gerry H]

Thanks Jeanette,

I have since established that some active X controls were missing from the
install and i needed to start a dummy project to initialise them.

It worked fine after that.

Again, many thanks,

Hi Gerry,

here is an example from A2003 help. You may need to create a new macro in
A2003.
This example is used to set the SupplierID control to the current supplier
on the Suppliers form.

Action is SetValue
Item: [Forms]![Products]![SupplierID]
Expression: SupplierID

Jeanette Cunningham

Hi,

I have just converted a 2000 database to 2003 and now my macros dont work.
They should be quite simple and are for setting up OK and Cancel buttons
on a
form to populate a query.

The error i get is related to the Action "SetValue" (when OK is pressed),
previously the parameters were Item - Visible and Expression - yes

The error I now get is that the expression is invalid.

Any help would be apreciated.