sql - In a continuous form, can I have a combo box use a different query depending on a field or text box value within its own record? -


edit: wondering, it's apparently impossible have same combo box 2 different records in continuous form refer 2 different queries populate list.

i have continuous form has maybe 5 records. there combo box, laborer1, , dropdown different each form, depending on other factors. managed put exact query want each record's combo box text field within record. next step? can manage @ point apply query of 1 record combo boxes, want each combo box use "own" query.

thanks!

yes, can it, there's tradeoff: inactive records may have value doesn't fit within current rowsource combobox. when happens, you'll blank combobox, instead of having show current value. if activate record, value appear again, it's not fantastic user experience.

that said, 1 option handle in form_current event. since you're storing rowsource in database field, code short:

private sub form_current   laborer1.rowsource = referencefield.value   laborer1.requery 'i don't believe need this, might. end sub 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -