Finding and Displaying Fields in a form w/3 fields

[Guest]

Hello. First timer

I have a table that holds 3 different fields
and what makes each record unique, is the combination of the 3 fields put
together
I'm not sure what method to use to have the fields display on a form.
I've tried using 3 combo boxes together looking up the fields in the table but
i was unable to figure it out.

I want to be able to choose the from the first Fields Community Name-(only
see them grouped so i only have one Community and after i choose the
community, when i go to the Lot Field, i only see the 2 options available
under that one community. (that it only displays values based on the
community selected)

here is an example of how the table is.
Community Name LOT BLOCK OTHER FIELDS...Address. ,Type
etc.
JESCA 1 1
JESCA 1 2
JOHNSON 1 2
JOHNSON 2 3
FLIER 1 1
FLIER 2 3

any help is appreciated
Thx

 

[Jeff Boyce]

Pete

Take a look at mvps.org/access, and at Google.com, and in Access HELP for
"Cascading Comboboxes".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Pete

"Cascading" handles more than 2 (I've used three, but only rarely).

Regards

Jeff Boyce
Microsoft Office/Access MVP