I have a contact management db with out clients, each of their locations and all of our possible contacts for each location.
I've built a form with cascading combo boxes for the group and location numbers, then a subform which contains all of the data for that particular group-location.
When I add a new contact in the subform, however, it leaves the group and location numbers blank.
Is there a way to set the forum up so that when a new record is added in the subform to automatically fill the group and location fields with the data that in the group and location fields in the main form?
I've attached a sample of our db for review. If possible, look at the form "GLC_Info" to see what I'm talking about.