setting field to null

[fishqqq]

I have a macro that opens a query and copies a record creating a
duplicate with a new auto number
This works perfectly. Now i want add to the macro to go to field
[CustomerRef#] . and it goes to the new record and the right field.

What i want to do is set this field to Null (empty) but i don't know
how.

The "set value" function wants an Item name which i give as follows:
[Query]![qCopyShptTracking]![Customer Ref #]
but the macro gives an error message " there was a problem referencing
a peroprty or method..."

can someone tell me how to reference this correctly? i know how to do
this in a form but not in a query.

Tks
Steve

 

[Tom van Stiphout]

On Mon, 1 Dec 2008 11:58:43 -0800 (PST), "(e-mail address removed)"

I never use macros but I would be really surprised if they can do
this. [Query] is interpreted as a form name, which is not found.

MUCH better to create a form to do these things.

-Tom.
Microsoft Access MVP