Create option group without using wizard

G

Guest

I am creating a database for the company I work for in Access 2000, and the
database seems to be operating pretty well. I've now been asked by the big
guy to include a section on the form that displays the result of the course
that clients have participated in. The most practical option would be to
insert a combo box. The combo box will have three options; pass, fail, or
attendance only, with the ability to choose only one option out of the three.
My problem is that the wizard that enables me to set up this function has not
been installed correctly on the PC, therefore I'm at a (seemingly) dead end
as to where to go from here. I've been waiting for the PC whizz to come and
reinstall the program again but he appears to have vanished into thin air. Is
there any way I can get around using the wizard and still get this combo box
up and running?

Thanks in advance
Katharine Jansen
 
A

Arvin Meyer

For an option group, just place a frame on your form. When you select a
radio button, toggle button, or check box, and move your cursor over the
option group frame, the frame will turn black and you click where you want
the button. Add 2 more of them and open the Property sheet. Select the data
tab, then enter the Option Value.

For a combo box, add it to your form, then either set the row source type to
Table/Query and use a 3 record table as a row source, or set the row source
type to Value List and type in the 3 values in quotes and separated by a
semi-colon in the row source.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
G

Guest

Hi Kat,
Go into the form's design view, and add an option group control to the form.
When you add the control, a wizard will display to guide you the rest of the
way.
Important, since you'll now be using an option group, change the field's
data type to "Number" in the source table. This will gain you some drive
space, and make the users' choice a tad easier to make.
HTH
 
G

Guest

Hi Arvin,

Thanks for your advice. I've tried both methods you've suggessted which look
good but they are not functioning in the way that I want them to. My aim is
to get the option group with the toggle button to work in a way whereby it
keeps the result on the basis of the client record that I am in. For example
if I input that client 11 has passed, and that client 15 has failed, then
when scrolling through the remainder of the form it will show the same
outcome for all clients on the basis of the last toggle button pressed,
therefore not working independently according to each record. On the other
hand, when using a combo box, it will only enable me to enter one of the
three values as the default value, therefore if I choose pass, then all
clients will have passed irrespective of the outcome.

I assume I have done something in error here. Can you shed any light as to
where I may have gone wrong??

Thanks in advance
Katharine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Create option group without using wizard? 2
Combo box wizard not working as expected 9
Problems with creating a combo box that would find a record 5
Option Groups: Can I Group the Buttons AND the Box They're In? 2
How to create an option group with multi-selectable check boxes 3
Form Wizard Errors 3
Form Help - autocomplete? 8
Using a combo box as a filter 1

Top