I have a Client Form with an AssignedTo field that uses a Combo Box to select the Counselor Name.
The Combo Box pulls Counselor FirstName from a Query: 'CounselorActiveQ' The query has other fields: License, Fee, & LowFee.
Is there a way to auto populate the Fee & License, etc after the AssignedTo Field is populated with the FirstName?
I've just seen another post recently asking much the same question, but I couldn't quite make it apply to my situation.
The FirstName field is correctly showing and populating. But I cannot figure out how to get the other 3 to populate.
Thanx in advance for any help.
Just trying to be helpful for data entry folks,