more than one check box in a field

[Guest]

I want 3 options in one field - a drop down box would probably work in stead
but can't to that either :s

Basically I have several fields which need different options eg. Field Name
Pay Status - options are then - Paid - Awaiting invoice - Received Invoice

or

printing

options are leaflets - posters - other

How do I set this up?

Thanks

 

[Guest]

Use the list box option under Lookup in the design view of othe table. Your
options (paid, awating, etc) are in another table which the list box points
to.

 

[Steve Schapel]

Funky,

On your form, put an Option Group control, bound to the field in
question. It is the more standard convention to use Option Buttons
rather than Checkboxes in an Option Group, in cases such as this, but in
practice you can use either. Using this design, you will note that the
data actually stored ion your table is an integer, corresponding to the
Option Value of the Option Button/Checkbox selected, so at times you
will need to use expressions to "convert" this integer to the equivalent
text description when needed as such for reports etc.

The other option, which I think you were suggesting yourself, would be a
Combobox. In this case, the options are determined by the Row Source
property of the Combobox. You can make a simple table, one field, where
you enter the items, e.g. Paid, Awaiting, etc, and then use this table
as the Combobox's Row Source, or you can set the Row Source Type
property to 'Value List', and then type the options directly into the
Row Source property, like this...
"Paid";"Awaiting invoice";"Received invoice"