Populate a Textbox with the help of Check Box

[manoj9849967222]

Hi All

I have a text box named Producode. Also i have some Check boxs like

1----- RTU
2------LTU
3------STU

Now i want that when ever i check any of the Check Box Say "RTU". It should get populated to the Textbox i.e Productcode.

I have tried to do it. but still i am un able to make it.

Please help.

Regards
Manoj

[Rabbit]

What have you tried?

[manoj9849967222]

Hi

I am trying this using a append query. The query runs but it does not shows any value. Neither it gets added to the Text Box.

Please help.

[Rabbit]

Why not just use a combo box or a listbox with those 3 values?

[manoj9849967222]

yes it would do but i would be great if it can be done using a check list.


Regards
Manoj

[Rabbit]

Then in the after update event of each box have it assign the value to the text box. An append query doesn't affect what's on the form unless the form requeries it's source. An append query only adds a new record to a table.