 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Toggle help
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! 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! 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? > [quoted text clipped - 17 lines] >> >> Any help is greatly appreciated. Thanks! 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 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, >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 [quoted text clipped - 8 lines] > >Ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.