Pass combobox to another form always = Null

mercredi 25 mars 2015

Hi Guys. Racking my brains on this one, been at it all day... and just can't figure it out...



I want to pass the Combobox value of one form to a textbox on another using the where condition. Using the break in VBA, the value of the combobox (in this instance "two") shows as null.



Have I missed something?



the control of the combobox is [cboSubCategory] and I want it's value to pass to another form "tblCategoriesSub" (aware of the incorrect reference, as used wizard quickly - but will change if I can get it to work) to the "SubCategory" field.



What have I missed? I'm guessing the use of the single quotes somewhere along the line? All are strings!




Attached Images









File Type: jpg VBAValue.jpg (60.1 KB)
File Type: jpg cboValue.jpg (3.3 KB)



Pass combobox to another form always = Null

0 commentaires:

Enregistrer un commentaire

Labels