list box row source

[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,

 

[golfinray]

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