Re: Option Group

anonymous_at_discussions.microsoft.com
Date: 04/11/04 

Date: Sun, 11 Apr 2004 12:58:28 -0700

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 and one form but I reaaly don't
know what recordsource you are talking about? If I go to
the form property and look at the control source it
says "tbbA" or "tblB", is this what you are talking
about? if not can you please be a little more specific
and elaborate on the steps? I have been away from Access
for quite sometimes and your specific information will
help me and save time to a great deal. Also, I am not
doing this for profit, its for a none profit organiation
and I am not charging them at all. Please help.

Condiser:

tblA
tblB

Option Group:

Book A
Book B
I want the data enteered though the form to go and sit on
tblA or tblB depending which button is selected.

Regards,

Mike

Regards,

Mike.
>-----Original Message-----
>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
>
>"Mike" <MieemAhlef@hotmail.com> schreef in bericht
>news:1af6801c41fa0$7ee7ded0$a301280a@phx.gbl...
>> 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
>
>
>.
>