drop down box

[Guest]

I am trying to build a basic database of clients. One of the fields is going
to be the measurement of the ad they are buying 1/16, 1/8, 1/4, or full page
and I am trying to make a drop down box with those options. But for some
reason I just can't figure it out. Please, anyone who explain it very simply
to me, I would definetly appreciated. By the way I have all the fields that I
need all I need it's just that. Thank you!!!!

 

[fredg]

I am trying to build a basic database of clients. One of the fields is going
to be the measurement of the ad they are buying 1/16, 1/8, 1/4, or full page
and I am trying to make a drop down box with those options. But for some
reason I just can't figure it out. Please, anyone who explain it very simply
to me, I would definetly appreciated. By the way I have all the fields that I
need all I need it's just that. Thank you!!!!

Are those the ONLY possible choices? Forever?

Set the Combo Box RowsourceType to Value List
Set the RowSource to:
"1/16";"1/8";"1/4";"Full"

If the possible values can change, then create a "PageSize" table, and
enter the values in a field in the table.

Now set the RowsourceType to Table/Query
Set the Rowsource to a query, based upon the table.

 

[Guest]

Hello! Not sure if anyone responded yet, but here's what I do.

In the table design view, locate the field you use for the measurement.
In the Data Type column, select Lookup Wizard.
Within the Lookup Wizard you can either key in the information or link to
another table with the applicable information.

Hope this helps!

Star Taylor

 

[Scottgem]

Do you need to do costing of the ads? Will ads be renewable? Does each
renewal constitute a new contract?

As you can see your question is not as simple as it might seem. Fred
gave you an answer that will create a drop down to select one of those
options. But how you use those options reflects your database design and
may require an alternative solution. So please explain further so we can
help some more.

HTH
Scott<>
Microsoft Access MVP 2007

 

[Scottgem]

Actually, most developers recommend NOT using Lookup fields on the table
level. Lookups should be done on the FORM level using combos and lists.
You might want to check out this article:

http://www.mvps.org/access/lookupfields.htm

 

[geronimo frias]

I am trying to build a basic database of clients. One of the fields is
going
to be the measurement of the ad they are buying 1/16, 1/8, 1/4, or full
page
and I am trying to make a drop down box with those options. But for some
reason I just can't figure it out. Please, anyone who explain it very
simply
to me, I would definetly appreciated. By the way I have all the fields
that I
need all I need it's just that. Thank you!!!!