Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup Column Dynamically

Status
Not open for further replies.

JanetFan95758

Programmer
Nov 29, 2002
3
US
I have a column in a form ("myForm") called Category, and another called Sub Category. Category is set to A, B, C or D. If A is chosen I'd like Sub Category to list 1,2,and 3. I have created a list called lstCategories on the site that has the A B C D categories with the corresponding possible sub categories.

How can I make the sub Category list (which is linked to the Sub Category column of lstCategories) show only the values that match the Category?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top