frmSites needs a query to include "State" as part of your Record Source. Think I am getting you and this is now done I think
The Control State should be a Text Box not a Combo Box. Done
Site Name is not required in the sub Form. My mistake that was dumb... site is already chosen it is the clients for the site I am trying to show, edit, add
Going back to States. You need a Form to add Cites and their State. This can be called when a new City is not on the list.
Think this is done as well, States list needs an element not to allow duplicates
Hopefully, I am getting your technique now
Sorry didn't get a chance to clean database yet
The only thing I think I have not got right this time is the not in list (the other things I did pretty much straight away and spent the whole time on this but keep getting the item is not in list error message)
Thanks
Attachment 4884