Pasting Data Selected by Check Boxes

[Crampton]

Hi Everyone.

Im sure one of you out there knows the answer to my bugging problem, ive looked through ( and through !! ) Access help with not much luck.

I have a series of check boxes as follows: Part A, Part B Part C etc etc. What I would like to happen is that when a check box is selected ( on a form ) it pastes the field heading ie Part A, B etc in another field. What is happening at the moment when i click on a check box it justs puts -1 in the other field and not the data title.

Basically a customer has a standard set of parts to choose from but i have a list of extras that they could also select from, ie Parts A, B etc, so when a customer selects these extras it appears in a quotation. If the customer does not select an extra then no data appears in the quotation.

Sorry if i have not explained this very well, but i just require the field name pasted into another field and not the -1.

Many thanks for your help, and sorry for confusing you lot !.

 

[IMO]

Create 4 hidden text boxes on the form (or however many are needed). Set the default value to part A, Part B etc etc. Now put the following code in the click event of the check box

Private Sub Checkbox_Click()
If Me.Checkbox = True Then
Me.YourTextFieldToPasteTo = Me.YourHiddenTextField
Else
Me.YourTextFieldToPasteTo = ""
End If
End Sub

Hope this helps

IMO

 

[Crampton]

Pasting from check boxes

Thanks IMO, that was just the ticket.

Its worked perfectly.

Thanks for your help

 

[IMO]

Glad you got it working

IMO