Sub-Form w/ Pick List Choices

[oftenconfused]

My apologies if I have the terminology slightly wrong. I chose my Display
Name for a reason....

I'm trying to create a database with the following properties:

[all on the same row on the input Form]

| A | B | C |
| A | B | C |

Where,
Field A: is a unique field
Field B: fulls from a list choices that could grow, but which is not
shared with any other table
Field C: pulls from a list of choices that could grow that is shared with
other tables

I'm having a really tough time getting it to work. I'm not sure if I have
the links right. Or, maybe it's in the way I created the Form.

Urgently seeking help before I go crazy.

Thanks in advance

 

[Piet Linden]

My apologies if I have the terminology slightly wrong.  I chose my Display
Name for a reason....

I'm trying to create a database with the following properties:

[all on the same row on the input Form]

|   A   |   B   |   C   |
|   A   |   B   |   C   |

Where,
   Field A: is a unique field
   Field B: fulls from a list choices that could grow, but which is not
shared with any other table
   Field C: pulls from a list of choices that could grow that is shared with
other tables

I'm having a really tough time getting it to work.  I'm not sure if I have
the links right.  Or, maybe it's in the way I created the Form.

Urgently seeking help before I go crazy.

Thanks in advance

Are you talking about cascading comboboxes? If so, read this article:
http://www.mvps.org/access/forms/frm0028.htm

You might need to find the article by Keri Hardwick about referencing
subform controls, too....