list box row source

D

deb

Access 2003

On my form called f018ContrPerfEmissGua (PK GuaID SK ProjectID) I have a
list box called UnitType.
I need help with the row source

If UnitNo=0, listbox shows all UnitType where ProjectID =
mef018ContrPerfEmissGua.ProjectID

else listbox shows UnitType where UnitID = mef018ContrPerfEmissGua.UnitD

How can I make this work for rowsource in a listbox or combobox?

Thanks,
 
G

golfinray

Could you make the rowsource a query with an IIF statement to select that for
you?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compare fields in listbox 3
combobox rowsource "All" if more than one in list 3
populate table using multiselect listbox 1
Unable to display values in 2nd list box from 1st list box selection 2
aut generate tab 1
Use same form in each tab 0
reuse form 2
if duplicate goto record 3

Top