troubles with autonumber within macro argument

[focosi]

I'm trying to incorporate a macro within the AfterUpdate event of a combobox which should autofill the field :

ACTION Search Record
ARGUMENTS ; ; First; ="[ID] = " & Int(Nz([Screen].[ActiveControl];0))

...but this doesn't work
Actually [ID] is an autonumber field, so I am not sure Str is right.... but I don't know syntax alternatives..

[rpeare]

what are you trying to accomplish?

Are you just trying to retrieve the most recent ID before the record is actually appended to your table? Basically the next valid autonumber field?

[focosi]

No, rpeare, mine is a macro incorporated within the afterupdate event of an unbound combobox.
It works at autocompleting ID in the control according to the first digits that are entered, suggesting entries based on records already found in that field.
This works like a charm when the field to autocomplete is a text field, but ID is an autonumber... and the macro doesn't work as it is

[rpeare]

you can probably use the cstr/clng (change to string/change to long integer) to do your checking if it's an issue between alpha/numeric. So your input search would be text, and if it's a combo box for instance you'd have the ID as the bound column and the display column set to cstr(ID)

[focosi]

can't understand how to do what you suggest...