Option Group

[Mike]

Hi everyone,

I am trying to create an option group to be placed on a
data entry form with two radio buttons "A" and "B". "A"
referes to my payment revceive A book And B to my payment
receive B book.

I have created two tables: tblA and tblB, both contain
similar feilds except one has only payments arrives but
the B has Paymnet type on servicerecived, downpayments,
and parts. I guess what I am trying to do is to use one
form and based on choosing option A or B the data goes
and sit in the corresponding tables. Is this possible?
and if it is, I would appreciate any help suggestions
that I can get. I have tried making the Option Group but
it is always inactive!

Please help me stay on course.

Regards,

Mike

 

[Perry]

Yes, but you will have to change the
recordsource property of the form to the selected optionbutton.

If the tables are designed similarly (same fields, same names for same
purposes)
you won't have any problems rebinding the controls on yr form.
If not, you might have to change the controlsources of the controls
alongwith.

Krgrds,
Perry

 

[Perry]

Yes they have the same feilds and since thay have the

same feilds on bother tblA anf tblB I have decided to may
be have one table only

This makes sense. Since y're talking about same fields and same
purposes, then your datamodell doesn't require two seperate tables.
Make one table, and include an extra field (eg. 'category') to make
the distinction between the records.

The Option Group can be a bound field pointing to this extra
field you created. The only thing you will need to consider is following:

Since you want to input/maintain the value of this extra field
by means of an Option Group, you'll have to matchup the datatype
of this field accordingly.
I would advise:
Numeric (long integer)

Krgrds,
Perry