Hello,
I've a combo box in my form and value of column 2 is being used in generating other number on the form due to which I've to set bound column to 2. But for the Control Source, I want to store value of column 1 (PK) because column 2 is not unique.
What I know is I have to set cboGroupCode to unbound with bound column 2 so that value from column 2 can be used in generating other number on the form. I will also need to create a bound text box (visible properties set to No) to use this text box to store value of column 1 of cboGroupCode in control source. I also know that I have to use after update event of cboGroupCode. What I don't know is, what would be the vba code or macro. Or what I think I know is totally incorrect there should another way of doing it.
Can somebody please guide me?
Best Regards,
Abdullah
I've a combo box in my form and value of column 2 is being used in generating other number on the form due to which I've to set bound column to 2. But for the Control Source, I want to store value of column 1 (PK) because column 2 is not unique.
What I know is I have to set cboGroupCode to unbound with bound column 2 so that value from column 2 can be used in generating other number on the form. I will also need to create a bound text box (visible properties set to No) to use this text box to store value of column 1 of cboGroupCode in control source. I also know that I have to use after update event of cboGroupCode. What I don't know is, what would be the vba code or macro. Or what I think I know is totally incorrect there should another way of doing it.
Can somebody please guide me?
Best Regards,
Abdullah