Hi Richard. Currently working on Expert 4 Lesson 4 Family member form. Using ACCESS 365.

When i try to follow your example creating the RelativeTypeF. I am trying to get the list of types alphabetically.

Using SQL  as shown I type in the Form Record Source my SQL statement. "Select * From RelativeTypeT Order by Description"  Save the form, close it and then reopen it. I get an error message which reads:

The record source "Select * From RelativeTypeT Order by  Description" specified on this form does not exist.

Any ideas where I am going wrong

Mike