How do I?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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.
 
Back
Top