Macro Action selection (1 Viewer)

BJF

Registered User.
Local time
Today, 07:21
Joined
Feb 19, 2010
Messages
133
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

Wino Moderator
Staff member
Local time
Today, 04:21
Joined
Aug 30, 2003
Messages
36,118
I don't use macros but it's either SetValue or SetProperty depending on version.
 

Insane_ai

Not Really an A.I.
Local time
Today, 07:21
Joined
Mar 20, 2009
Messages
264
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.
 

Users who are viewing this thread

Top Bottom