Radio Buttons Help Pls!!!!!!!!

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

Hai Guys,

Iam trying to develop a database for a flying club which has log the details
of all flights happened.
In this in the main form of data entry i have a radio button for the Type of
Flight of taken (SOLO or DUAL ) as a option group having two option Dual or
Solo, and i am saving the data collected from this table into main table
called AccountTable

The problem is value that is saved into table will be numeric 1 or 2
according to choice.I dont want this to happen , Is there any way i can save
to table as text like Solo or Dual?????????????

Thanks for the help in Advance...........
 
Joe

Why? As in "why do you care how the data is stored as long as your form
shows "Solo" or "Dual"?"

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff
Thanks for the reply.

I need it to stored as Solo or dual bcoz iam retrieve the data from tht
table on latter stages which i needed to be shown as dual or solo.

for example.
in latter stage iam making a daily report of all flights on a particular
date ,at tht stage i want this field(Type of flight) as Dual or Solo instead
of 1 or 2

Thanks for the help
 
Thanks Buddy ...........
tht solved my problem for now........


Bob Quintal said:
Jeff
Thanks for the reply.

I need it to stored as Solo or dual bcoz iam retrieve the data
from tht table on latter stages which i needed to be shown as dual
or solo.

for example.
in latter stage iam making a daily report of all flights on a
particular date ,at tht stage i want this field(Type of flight) as
Dual or Solo instead of 1 or 2

Thanks for the help
Click to expand...
in the report, put an unbound textbox, set its label to "Type of
Flight". In the textbox itself you would enter
=iif([type of flight] = 1, "Dual","Solo")
Click to expand...
 
Back
Top