How do I set a value of one field based on the value of a previous

[Guest]

Hello, I need some help on how to update a form.
I would like to set a value of one field based on the value of a previous
field.
I have a table "ACTIVITY" with several fields, but I need to focus on 2
fields: "Technology" and "Base Release"
"Technology" pulls a list of technologies from another table "TECHNOLOGIES".
These list includes A, B, C and D.
I would like to do this: When the user selects the technology (i.e. A), I'd
like to then provide a list of releases (in "Base Release") based on the
technology selected (using a combobox).
On a third table "RELATIONSHIP" I have a mapping of "Technology" and
"Releases". One "Technology" can have multiple "Releases". For example,
technology A, can have release A.1, A.2, A.3, etc.

If you could provide some guidance on how to do this, I'd really appreciate
it.

 

[Brendan Reynolds]

I think you're trying to filter the contents of one combo box based on the
value the user selects in another combo box? If so, there's an example at
the following URL ...

http://www.mvps.org/access/forms/frm0028.htm