How do I?

E

Eskimo Going Nuts

Need help with problem. My Database is about information gathered in various sites.

I have three Tables

Tbl.Mai
-fld.Visit_ID (Primary, Autonumber
-fld.Observer (Text
-fld.Latitude (Number
-fld.Longitude (Number

Tbl.Land Cover Type
fld.Land_Cover_Type_ID (Primary, Autonumber
fld.Land_Cover_Type_Name (Text) (There are fifteen types, ie.. Boulder, Rock, Sand, Gravel...etc.

Tbl.Land_Cover_Characteristic
fld.Observation_ID (Primary, Autonumber
fld.Visit_FK (Number) (Linked to [Main].[Visit_ID]
fld.Land_Cover_Type_FK (Number) (Linked to [Land Cover Types].[Land_Cover_Type_ID]
fld.LCT_Percentage (Number) (The percentage of each cover type I am entering

In a form, how do I get the 15 types of land cover so that I can enter them easily. I would like each 15 land cover types visible for entry in the form. Right now, with the way I have it set-up, I am required to specify the Land Cover Type and then the value.

Please help. Thanks alo

Eskimo going nuts
 
C

Clarence

In the form make sure the control wizards button is
pressed in the form toolbox (design view).....

Then click on the Combo-Box button and follow onscreen
prompts..., also in the help file you can find other ways
of accomplishing this. I used the phrase combo box in
form and brought up several examples in Access 2003.

Hope this helps...
Clarence

In a form, how do I get the 15 types of land cover so
that I can enter them easily. I would like each 15 land
cover types visible for entry in the form. Right now,
with the way I have it set-up, I am required to specify
the Land Cover Type and then the value.
 

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

Top