access form using toggles

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.
 
S

strive4peace

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 :)
*
 
D

datamanipulator

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.
 
D

datamanipulator

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Clearing combo boxes and a text box 2
Copy previous record into form field 0
Tracking Resources as Trade Types - Rather than Individuals 1
Autonumber field in Excel that behaves the same as Access 0
Re-title multiple MS Project .mpp files at once 0
QBF Form: Disabling Toggles based on Report or Criteria 0
Possible to Combine reports to's to a single box? 0

Top