Trying to get a property set based on a combobox selection in access 2010 -


i thought had figured out i'm trying set value of field in form based off of 2 combobox selections. first few tested worked out ok when added more stopped getting results.

snippet of code far:

if (product_select = "krystar 20kg")     if (batch_number_select = "batch 1")         docmd.setproperty "text5", , "60"     elseif (batch_number_select = "batch 2")         docmd.setproperty "text5", , "61"     elseif (batch_number_select = "batch 3")         docmd.setproperty "text5", , "62"     elseif (batch_number_select = "batch 4")         docmd.setproperty "text5", , "63"     elseif (batch_number_select = "batch 5")         docmd.setproperty "text5", , "64"     end if end if 

anyone see wrong? syntax looks eyes.

i don't use docmd.setproperty, had up. default value second parameter acpropertyenabled, whereas looks want setting acpropertyvalue. there reason me.text5 = "60" wouldn't work you?


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -