I am trying to setvalue of a field according to result of another field and was looking to record multiple options.e.g. [County] in ("Armagh",Tyrone","etc") set value of field province to "Ulster" or [County] in ("Galway","Mayo","etc")setvalue of field "province" to "Connacht" I can get one to work but not multiples. Thanks
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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Macros
- Thread starter Grieve1
- Start date
You should use a look-up table. The table should include county and province, you may also with to include additional information such as north or south. When you have built the look-up, you can use a cascading combobox:
ádh mór!
ádh mór!
- Status
Similar threads
- Locked
- Question
- Locked
- Question