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