Just when I thought I was getting the hang of things.... this happens!!
See screenshots here:
https://1drv.ms/f/s!Auf81kbPTMG1gYIVxLZtSBtasfobAw
SampleDB07222019.zip
I have one table that lists all the Addresses and another table that contains information for Trips. In the Trips table, instead of having two sets of fields to enter starting address and ending addresses, I had thought it would be better to put all the addresses in one table and simply reference the the from and to addresses with the Addresses table.
Everything was looking good and it seemed like a sound idea, but when I went to create the form, it just displays the From Addresses twice!
If you look at the screenshots, in the Query Builder for the form, I have the Trips table, the Addresses table and a States table. I created aliases for those so I wouldn't get confused, so we have FromAddresses and FromStates. I added the two tables again, and named them ToAddresses and ToStates. You can see how I linked them together in the screenshot.
When I run the query, the information is correct. But after I drag the ToAddresses and ToStates fields into the form and then go into Form View, it just displays the FromAddresses and FromStates twice. When I go back into Design View for the form, I see that the secord group of fields automatically changed from the ToAddresses to the FromAddresses. Even if I change the control source for one of the controls, after I go into Form View, it just changes back.
How I can I fix this and get the behavior I want?
Thank you so much!