setvalue macro

[pedro]

I would like to create a setvalue macro that populates a field based on the
value selected from a combo-box in another field.

I would set the value of the field based on the result of a saved query.

I'm not quite sure of what I should place in the 'expression' of the macro.

Thus far, I have

Action: setvalue
Item: [Vehicle Shape] This is the field that I want to populate
Expression: Query1 (?) - not sure of the syntax or if I should use the
expression builder.

thanks for your help.

Pedro

 

[bhicks11 via AccessMonster.com]

Hi Pedro,

If it is a parameter query that gets it's parameter value from the combobox,
run the query after selecting your item from the combobox and make the
parameter value = the combobox.

Is that what you are trying to do?

Bonnie
http://www.dataplus-svc.com

I would like to create a setvalue macro that populates a field based on the
value selected from a combo-box in another field.

I would set the value of the field based on the result of a saved query.

I'm not quite sure of what I should place in the 'expression' of the macro.

Thus far, I have

Action: setvalue
Item: [Vehicle Shape] This is the field that I want to populate
Expression: Query1 (?) - not sure of the syntax or if I should use the
expression builder.

thanks for your help.

Pedro