Option Buttons to display properly

  • Thread starter Thread starter DHB
  • Start date Start date
D

DHB

I have a table named "Registration"
with a field "How_Pd"

My form has an options group "Payment Method"
which has three option buttons "Cash", Check, and C_Card"
which are installing in the field the values "CH, CK,
and CC" respectively.

How do I get the form to read the table, set the value of
the option group, and display the buttons properly --
selecting the right button, as I step through the records.
 
I should tell you that I am using Access 97.

As an advanced programmer in Visual dBase, I am trying to
make the transition to Access. is there a good printed
resourse that you would recommend, that defines all access
functions, commands, etc., and has plenty of code
displayed?
 
I have a table named "Registration"
with a field "How_Pd"

My form has an options group "Payment Method"
which has three option buttons "Cash", Check, and C_Card"
which are installing in the field the values "CH, CK,
and CC" respectively.

How do I get the form to read the table, set the value of
the option group, and display the buttons properly --
selecting the right button, as I step through the records.
Click to expand...

The Option Group should be bound to a field in the table.
You do this be setting the Control Source property of the group to the
appropriate field in the table.
 
You could try to make the option group with the wizard? The wizard is great
help.

If you bind the option group to that one field that stores the 3 possible
values, then the whole process is automatic in ms-access.

In other words...if you got this right...then the option group will change
from record to record....

If option group is NOT changing from record to record, then either the
records don't have any values just yet...or your option group is not bound
to the field.
 
One of the best books (set) that I have found, with lots of examples, all on
a CD that comes with the book, is the Access 97 or Access 2000 Developer's
handbook" by Ken Getz, published by SYBEX. A great reference. For VBA
specific reference get the book "VB & VBA In A Nutshell". Both books are
available for Amazon.com at a discount.
The developer's handbook covers you problem specifically.
Cheers,
Henry
 
Back
Top