access form using toggles

  • Thread starter Thread starter datamanipulator
  • Start date Start date
D

datamanipulator

I plan to use toggles to enter one of three options of watershed names on a
form- and would like to be able to get the "names" associated with the
toggles written to the data field in the table associated with the form
rather than the digits 1, 2 or 3.
On Key Press, Set Value, "WatershedName" does not do it, any help would be
great.
 
option frames can only store numbers. They do not have to be 1,2, pr 3
-- but they do have to be numbers

If this is a single form, you can use the current event to fill the
option frame based on text values -- then use the option frame
AfterUpdate event to populate the field with the text value. This is a
lot of coding -- the easy way is to change the way that the data is
stored...


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Thank you Crystal.
I proposed using the toggles as to ease the input of what will be hundereds
of records- all with one of three watersheds as part of the location data-
and rather than type- and possibly mis-type- the same data I would like to
simplify the process- any alternative controls that would deal with text you
could recommend?

Thanks.
Mary.
 
Thank you for that suggestion- I had already moved in that direction!
And for the connection- I have recently had to do more with access than just
data manip. so am in need of some tutorials!
 
Back
Top