Is the .column property available in Access macros (1 Viewer)

[GoodyGoody]

HI, I want to check the value of column 3 in one of my combo boxes in a macro but Access doesn't seem to make it available to macros where of course it is available in VBA. Am I missing something or is my syntax wrong for the macro: cmbSeriesID.column(2)? Thanks, Stephen

 

[zeroaccess]

You may need to create a public function and call it from the macro.

 

[isladogs]

But of course doing that means you are using code anyway....so you may as well scrap the macro.

 

[Micron]

maybe you are not starting at the correct place in the hierarchy. Maybe Forms!myFormName.cmbSeriesID.column(2) ?

 

[arnelgp]

you can get the value of any column of the combobox using Macro.
you can even assign the value to a LocalVar or to Tempvar.
just make sure to enclosed the comboname in square bracket, eg:

[cmbSeriesID].Column(2)

remember also that Column number is zero based (meaning, to refer to column 1, [cmbSeriesID].Column(0)).

 

[GoodyGoody]

Thanks. I'll just do it in VBA as there are some other tests I need to do anyway and it will be neater.