combo boxes and check boxes

[Shreekant Patel]

Hello,

I am new to the advanced level of access, and I have quite a few
changes to make to an existing database.

The current database's main form needs to have additional check boxes
added to it which in turn are meant to be linked to relevant tables and
a combo box which hold relevant data specific for it.

E.g. If checkbox1 is selected then, in the combo box, all the relevant
data types would appear for checkbox1 from which the user can choose
from.

If checkbox2 is selected then the combo box would display the list of
data types only relevant to it.

I have created the check boxes and the relevant tables which will hold
the information. I also would like to know how I can have only one
check box selected at any time. I am aware of the options group, but is
there another way?
The Combo Box
The current database design is such that there is a text box which
needs to be converted to a combo box. All the information within the
text box needs to be preserved. How would I preserve that data and
make sure when converting to a combo box, only the new values will
appear in the drop down list?

The other thing I noticed is that when I created a new field within a
table, it does not seem to appear in the field list. Hence when
creating a check box I can't seem to point it to the right control
source.

Any help would be great. Thanks

Srm..

[Jeremy Wallace]

Srm,

This is a lot of questions for one post, but...

I would use an option group. What's your reason for wanting to do
something else? Standard practice, the one that everyone's used to
seeing, and will intuitive know how to use, is that, for a group of
options where only one can be selected at a time, you use radio buttons
(the round ones, not check boxes) and put them in an option group frame
so that users will know where the limited options are located, and how
to tell them from the other controls on the form. If you _really_ want
to buck this convention, and are willing to risk confusion on the part
of your users, you could use check boxes in an option group and make
the border of the frame be transparent, or the same color as the
background of your form, if you really wanted.

Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org

[Jeremy Wallace]

OK, on to the next part, changing the rowsource of the combo box
depending on what's selected in your option group <g>...

I would put code in the Enter event of your combo box that does
something like this:
select case me!WhateverYourOptionGroupIsCalled
case 0
me!WhateverYourComboBoxIsCalled.rowsource = "SELECT ..."
case 1
me!WhateverYourComboBoxIsCalled.rowsource = "SELECT ..."
case else
me!WhateverYourComboBoxIsCalled.rowsource = "SELECT ..."
end if

The select statements will pull the data from the tables you have set
up for the combo box.

One additional thought--it's likely that the tables you have to fill
the combo box could be combined to one table, with just a single field
to differentiate the groups of data. This is a cleaner design.You would
then be able to simply change the where clause on the select statement
in each of the cases above.

Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org

[Jeremy Wallace]

Fields not appearing...

Is your form bound directly to the table? It sounds like it's bound to
a query. If that's the case, you'll have to add the fields to the
query, too.

If it's bound to the table, is it possible that you made the changes to
the table while the form was open in design view? If so, close the form
and reopen it and you'll see the new fields.

Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org

[Jeremy Wallace]

Changing the text box to a combo box...

Right click on the text box and there's an option to change it to a
text box!
Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org

[Shreekant Patel]

Hi Jeremy,

Thank you for your help/advice. I am going to give a try and see what
the outcomes turns out to be.

Shreekant
Jeremy Wallace wrote:

Changing the text box to a combo box...

Right click on the text box and there's an option to change it to a
text box!
Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org