Toggle help

[Superfuzz]

I'm stuck. Trying to create a toggle button on a form that will enter a
specific value into a field on a table when clicked.

Example: Field on table is automobile makers. I want a click on the toggle
button (captioned as FORD) on the form to record Ford. I

s there a way to set the value so a the onclick enters this data in the table?


Any help is greatly appreciated. Thanks!

 

[Jeff Boyce]

Yes, but ... why?

If you have a form that has one button for each auto maker, then won't you
have to modify that form (and any underlying queries, reports, etc.) when
you have a new auto maker (or an old one declares bankruptcy)?

Another approach would be to use a combobox that lists all available
automakers (from a tlkpAutoMaker table), then bind the control to a field
that captures the AutoMaker. This way, when you need to change/add an auto
maker, you just do it on the tlkpAutoMaker table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Superfuzz]

Thanks for your feedback.

Yes I could a ComboBox and the problem would be solved. However I'm trying
to make the form 100% visual and without text. My toggle button has a photo
of a Ford car.

Best regards,
SF

Yes, but ... why?

If you have a form that has one button for each auto maker, then won't you
have to modify that form (and any underlying queries, reports, etc.) when
you have a new auto maker (or an old one declares bankruptcy)?

Another approach would be to use a combobox that lists all available
automakers (from a tlkpAutoMaker table), then bind the control to a field
that captures the AutoMaker. This way, when you need to change/add an auto
maker, you just do it on the tlkpAutoMaker table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I'm stuck. Trying to create a toggle button on a form that will enter a
specific value into a field on a table when clicked.

[quoted text clipped - 7 lines]

Any help is greatly appreciated. Thanks!

 

[Ron2006]

Assuming your user is into cars and recognizes a Ford from a Dodge. If
they are getting the information off of a form that is printed you
will have better results having them in a very simplistic sense
matching letters then trying to match letters with a picture of an
auto that in a while will be out or date or not match exactly with the
model of the car.

If you are bound and determined to use a picture then use the Ford
logo rather than a particular model. It will make your training
easier.

Ron

 

[Superfuzz via AccessMonster.com]

Thanks all for explaining several reasons why I probably shouldn't do this.
However unsound my request may seem I still would like to know how I could
accomplish this. If anyone has a solution to how I could make the toggles
i'm discribing for my 100% visual form I'd be very appreciative. I've
already spent a lot of time try to make it work myself and I'm getting no
where.

Best regards,