Hello,
I assume there is probably and answer to my question somewhere on this forum but I must not know how to find it. I'm sorry if I'm posting the same question somebody else has already put on here.
I have two combo boxes accountID and subaccountID on a sub form that are both based on tables in a one to many relationship. I want to be able to select a value in the accountID combo box and then have the subaccountID combo box update to reflect the related records in the accountID field. How do I accomplish this? Do I put an expression in the select query on which the row source is based?
I hope my question makes sense. If it's been asked already point me to the related posts.
This YouTube video shows what I want to do, but just on a sub form.
https://www.youtube.com/watch?v=at0uaGSnUco
Thanks,
Joel