Group Option & Setvalue Macro

G

Guest

I created a group option to present 3 choices for users and a macro to
setvalue to a text box for each choice to pass the parameters for my query.

My question is: how to clear the previous text boxes (or set them to Null)
if the user makes another choice after the previous ones?

My try didn't work:

[Forms]![Margin Dialog]![Frame17]=1 SetValue 0 to Text 26
[Forms]![Margin Dialog]![Frame17]=1 SetValue Null to Text28
[Forms]![Margin Dialog]![Frame17]=1 Setvalue Null to Text30
[Forms]![Margin Dialog]![Frame17]=2 SetValue 1 to Text 28
[Forms]![Margin Dialog]![Frame17]=2 SetValue Null to Text26
[Forms]![Margin Dialog]![Frame17]=3 SetValue Null to Text 26
[Forms]![Margin Dialog]![Frame17]=3 SetValue Null to Text28

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to setvalue of comboboxes to null 1
'SetValue macro action' problem 4
How to use setvalue to set form comboboxes to null 1
macro ordering confused? 3
SetValue Help 1
Create a form to enter report criteria macro troubles 2
Help reqd. with the Macro "SetValue" property. 18
receiving error message using setvalue on macro 8

Top