a variable in a method

[Rudi GOUSSEY]

Is it possible to use a variable in a method

Private Sub cmbFles_AfterUpdate()
txtItem.SetFocus
retvalItem.Value = "Bottle"
DoCmd.OpenForm "Failure Bottle"
End Sub

I would like to use an variable in code (just an example to illustrate) above as you see below, but this don't work. Maybe it is not possible

Private Sub cmbFles_AfterUpdate()
dim retval as string
retval = txtItem
retval.SetFocus
retval.Value = "Bottle"
DoCmd.OpenForm "Failure Bottle"
End Sub

Thx in advance for the help
Rudi

 

[Norie]

Is it possible to use a variable in a method

Yes

But not in the way you have in the second piece of code posted.

What do you actually want to do?

 

[Rudi GOUSSEY]

I'll try to explain

Suppose i have on a form

two comboboxes :
cmbCombo1 with items : bottle, cap, label
cmbCombo2 with items : red, blue, white

6 checkboxes
chkbottle
chkcap
chklabel
chkred
chkblue
chkwhite


I also have a table tblData with fields (boolean) :
bottlered
bottleblue
bottlewhite
capred
capblue
and so on

choosing bottle in cmbCombo1 makes the checkbox bottle on the form true
and choosing red in cmbCombo2 makes the checkbox red on the form true

If checkbox bottle and red are true the fieldvalue bottlered in the table shoud be true
If checkbox bottle and blue are true the fieldvalue bottlered should be false and bottleblue true

the same way for cap and label


If explanation unclear please let me know

Thx in advance
Rudi