[AccessD] selection by checkboxes

Hello Group,

i have a form in which i can make 10 selections for products, by checkboxes.
For each product their are several fields that contain data, also for each produkt there are several other checkboxes that gives you the possibillity for selections on different levels. With the data from these produkts i make standard letters with code Nr2 from Helen Feddema.

I have troubles with the code for making the right selections.

For example

If chbProduct1 = True then
.Item("ProductCode1").Value = Nz(Me![txtProductCode1])

' when this checkboxes is true the productCode1 must always be placed

' For this product1 i have 3 different checboxes. When one of these is True (only one can be true and only when chbProdukt1 = True) then i need the data places that belongs to this checkboxes

 chbA1 = True then
.Item("Aantal1").Value = "2000"
.Item("Prijs1").Value = Nz(Me![txtA1])

chbB1 = True then
 .Item("Aantal1").Value = "3000"
.Item("Prijs1").Value = Nz(Me![txtB1])

chbC1 = True then
 .Item("Aantal1").Value = "4000" 
.Item("Prijs1").Value = Nz(Me![txtC1])

' How can i place these code together in a way that when chbProdukt1 = true, the Produktcode is placed and i can make a selection of one of the three checkboxes A1, B1, or C1so that only the data from one of these checkboxes is placed.

' And this i have to do for then products, maybe in total there is a shorter way also.

TIA

Pedro Janssen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030716/b8146fd4/attachment.html>