Hello Chappys!
Im in quite a pickle here and Im falling down a rabbit hole.
I have a form that has a combo box that when selecting an account name it populates an unbound text box with an Account ID. Works flawlessly.
My issue is when I make sure that the "right hand is telling what the left hand is doing" i.e. when "Saved" via the form, it saves the record in the appropriate field on the table. It does not.
Instead of populating the "account name" field with the selected account name from the combo box, it populates with the ID and my Account ID field is a "0".
I have changed "bound column". I have swapped AccountID and AccountName fields in the query. Ive rearranged the VBA for the combo box...I'm lost and tired.
The VBA for the combo box on the form is from OnChange. textbox = combobox. Other than the usual VBA wording and lingo, thats the bread and butter. So then that populates the Unbound textbox to the Account ID. Looks great on the form but doesnt mean anything if its not recorded as such.
Someone please throw me a frickin' bone here. Thanks all.