Form tick boxes

[sagsh]

I have a form where users enter make and model of cars owned along with car features ie alloys, sat nav, electric windows, air con, sunroof
etc all these options are from one table.

I need to create a form where they can tick boxes next to the specific option which will need to update one field in another table seperated by a comma - can this be done?

Thanks for any help!
Sagar

 

[ReAn]

Yes it can...

Just add an event on the tickboxes 'AfterUpdate' event to update the other text box with the new combined value.

 

[Rich]

What if you haven't selected enough attributes or even too many after updating the field?

 

[sagsh]

Form tick box

How would I create an after update event? I think what you are suggesting is to concatenate the current value of whatever is in the field with the new value and store the updated value in the field. What would the code for this look like?

 

[WayneRyan]

sag,

That's not for a tickbox.

If you had a TextBox or a Memo field, you could use the AfterUpdate event
to:

Me.SomeField = Me.SomeField & vbCrLf & Me.SomeTextBox

Wayne

 

[sagsh]

Form Tick Boxes

Hi Wayne

Thanks for the update!

Could I not do something like -

if true (indicating tick box is ticked) the val='alloys' then

Me.SomeField = 'alloys'

Me.SomeField & vbCrLf & Me.SomeTextBox

etc. or am I totally wrong on this?

Best Regards

Sag

 

[WayneRyan]

sag,

You're right!

Just use the AfterUpdate event of the CheckBox.

Wayne