S
Sandy
Hello -
I have a form with several required fields.
I want to be able to refresh the data in one dropdown field on GotFocus,
based on the data in another dropdown field.
DD Field 1 is called categories
Cat_ID Category
1 Accommodation
2 Agriculture, Forestry and Fishing
3 Animals and Pets
DD Field 2 is called Sub-Categories
CatID Sub Category
1 Bed and Breakfast
1 Camping and Caravans
1 Hostels
the row source for the Sub-Categories field is:
SELECT SubCategories.[Sub Category], SubCategories.CatID
FROM Categories INNER JOIN SubCategories ON Categories.Cat_ID =
SubCategories.CatID
WHERE (((SubCategories.CatID)=[Forms]![Listing Form].[category]))
ORDER BY SubCategories.[Sub Category];
When the data in the Category field changes, how do I set the refresh on the
Sub-Category field only and not the form? Since all the fields are not
entered yet I get an error for the empty required fields.
thank you
sandra
I have a form with several required fields.
I want to be able to refresh the data in one dropdown field on GotFocus,
based on the data in another dropdown field.
DD Field 1 is called categories
Cat_ID Category
1 Accommodation
2 Agriculture, Forestry and Fishing
3 Animals and Pets
DD Field 2 is called Sub-Categories
CatID Sub Category
1 Bed and Breakfast
1 Camping and Caravans
1 Hostels
the row source for the Sub-Categories field is:
SELECT SubCategories.[Sub Category], SubCategories.CatID
FROM Categories INNER JOIN SubCategories ON Categories.Cat_ID =
SubCategories.CatID
WHERE (((SubCategories.CatID)=[Forms]![Listing Form].[category]))
ORDER BY SubCategories.[Sub Category];
When the data in the Category field changes, how do I set the refresh on the
Sub-Category field only and not the form? Since all the fields are not
entered yet I get an error for the empty required fields.
thank you
sandra