HT set value to a combobox itemfrom a previous form

[xalaros]

hello,

I am having two forms Customer details and Case details.

on the Customer details form I am having a button called New case, on click runs this code

DoCmd.OpenForm "Case Details", , , , , , [Customer name]

The case Details has the following macro :

Let me tell you that I am not very profficient in access thats why I am providing all the info. Also the file was an access template that I adjust it a bit to fit my needs.



The set value item Is a combobox which shows the customer name and there is my problem. I cannot make it take the value I am trying to pass through. althought when I change the field to a text box the customer name is shown perfectly.
Is this normal? could I be able to make it work or should I seek a different workaround?

[pbaldy]

It appears you're trying to put the name into a combo where the bound column is the ID field. Try passing the ID instead of the name.

[Perceptus]

I thought you couldnt use Tempvars without implicitly adding the new key to the dictionary first.
nvm, access 2016. man am I Jealous. One Day I will get there.

[xalaros]

@pbaldy thanks a lot.

I change it and now it shows up great. thank you for your time

[pbaldy]

Happy to help, and welcome to the site by the way!