Check Box Help

[spam]

I want to put some check boxes on a form that I have
created. When I select one of the check boxes I would like
the value of the check box stored in a table.

So to be more specific:

On the form there will be 3 check boxes:

1) Product x
2) Product y
3) Product z

When one of the check boxes is selected, I would like
the price of the product to be displayed in an exsisting
table.

product x price = 10
product y price = 20
product z price = 30

Any help is greatly appreciated.........

 

[DougP]

In the "After_Update" event of the check box put the other text boxes name that you want the informaion to go into.
like so

Private Sub Check4_AfterUpdate()
If Check4.Value = True Then
Me!YourPriceTextbox = somevalue
Else
Me!YourPriceTextbox = 0
End If
End Sub

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[spam]

Cool That works great!!!!!

I hope you dont mind but I have another question.

Lets say you do this with 3 different check boxes,

how would you add all 3 results into one text box

Thanks in advance