check boxes and combo boxes

  • Thread starter Thread starter moe-24
  • Start date Start date
M

moe-24

Hi
Am working with a database that is formatted in both
datasheet view and form view , the bottom part of the form
contains check boxes that are linked to the table, am
trying to add somemore check boxes but they come up shaded
and someone tells me that its because they arent linked
with the table is there a way someone can advice me on how
to go about this problem.PLEASE

secondly , combo boxes ? how do i get them in and start
working with them.

desparately learning
Moe
 
A greyed checkbox means its value is Null, which can be a symptom of it not
being bound to a column.
I presume you are tried to add a bound checkbox (one which has an underlying
field).
This being so you need to firstly create the field in the source
table.
Set its datatype to Yes/No, & under the lookup tab make sure it is
set as a checkbox.
Next open the form you are modifying, & assuming the
recordsource is the table, & not a query the new checkbox field should be
displayed in the field listing.
If you drag 'n drop the new field onto your form it should automatically be
added as a bound checkbox.


N.B. If you add a new Yes/No field, your existing records in the table will
be Null (Grey). To solve this, before you enter any data into the column,
run an update query, setting the value to false...
 
Check Box: Change the Control Source property to the
field of the underlying table.

Combo Box: Use the combo box wizard. Turn on wizards by
toggling the wizard icon on the Toolbox toolbar. Place
the combo box, tell the wizard the name of the source
table or query, and select the field(s) you wish to
display in the combo box. The most typical use of a combo
box is to display meaningful descriptive fields, but
actually store the key field corresponding to the value
selected. This will be accomplished automatically if you
select Hide Key Field. Then tell the wizard to which
field of the form's underlying source you want to put the
selected value.

To see what the wizard did, examine the Column Widths and
Bound Column properties (Format and Data Tabs,
respectively). The Column Widths controls the width of
the displayed columns. By hiding the key field, its width
was set to 0, which means that although the key field is
actually stored in the underlying table (since the Bound
Column is set to '1'), the second column is actually
displayed after the user has made a selection.

HTH
Kevin Sprinkel
 
Back
Top