Macro Action selection

[BJF]

Hi,

I'm not very familiar with using macros and I am wondering which action i need to choose to do the following:

I have a combobox and a listbox on my form.

The combobox uses a macro to find a record on my form but i need to add another action to that macro.

I want to set my list box to equal my combobox location but not sure whcih action i choose to put in the code.

The code will be:

List153 = Combo93

Can anyone help me please!
Thanks,
Brian

 

[pbaldy]

I don't use macros but it's either SetValue or SetProperty depending on version.

 

[Insane_ai]

Please tell us what version of Access you are using, it may change the response you receive.

My initial thought is that you call the macro from VBA on some event and include a line of code to make the change you need.

it would look something like this:
Dim myVar as varType
myVar = me.combo93
Me.listbox.setfocus
Me.listbox.[value] = myVar

Obviously, this is not tested code but it should lead to the answer.