Option button

A

Ashby

when an option button is selected I want to link it to a field in a table
with a yes/no value

ie
Table = Product Group
field = Tube (yes/no)

if option button is selected then tbe = yes.

How can I achieve this?

Thanks Ashby
 
A

Ashby

Really it would be the same problem with the checkbox gining a true/false
,-1/0 answer...
 
D

Damian S

I am assuming your form is getting its data from the Product Group table. If
so, place a checkbox on yoru form and set its data source to "Tube". It will
then save the value into the Tube field of the Product Group table when
someone clicks on it.

Is this what you are meaning? If not, can you provide a little further
information please.

Damian.
 
P

PCH

Hi damian

I've got about thirty different product types.
If I insert a frame on a form and link-bound the option buttons to store
their vaule in the field say "product type" I can only use 20 option buttons.

If a split these groups into two, making two frames with fifteen option
buttons in each, I run the risk of entering "two values" into the field...

I was really looking to create a frame with as many options as I'd like,
where only one is selected and it's product group updated to the filed.
 
D

Damian S

If you have 30 different product types, and it's only possible to have a
single product type selected, you should have the product types in a lookup
list (table) that is linked to your main table. Then you can have a single
combo box to display your 30 items and the user can only select one. If you
need a new product type, you simply add it into your table. Here's a sample:

tlkProductTypes
ProductTypeID autonumber
ProductType text

tblProduct
ProductID
ProductName
ProductTypeID

See what I mean?

Damian.
 
H

Harry

Just create within your table;
fieldname data type
tbe yes/no
This creates a checkbox in your table. checked=yes unchecked= no.
Working with its status can be done as
if me.tbe = true then "Whatever you want"

Harry
 
Top