Texbox #Error

[erich_18]

I have a Clear button on my form, this button clears the data from the comboboxes and refreshes the form so the textboxes show 0. here's the code in the button:



Me.cboOrigin = ""
Me.cboPOL = ""
Me.cboTS1 = ""
Me.cboTS2 = ""
Me.cboTS3 = ""
Me.cboPOD = ""
Me.cboDest = ""
Me.cboPOLMT = ""
Me.cboTSMT = ""
Me.cboPODMT = ""
Refresh

the button worked fine when my tables where in an access back-end, but after migrating my access tables to sql server (express 2017) after clicking the Clear button the textboxes show #Error. but when selecting data in the comboboxes the textboxes will show the correct values, its only after hitting the Clear button.

dont understandr why. any ideas?

expession in the textboxes:
=Nz(DLookUp("Column","Query"),0)

tks

[June7]

Maybe set them to Null instead of empty string.

Are these controls UNBOUND?

The DLookup is incomplete since there is no WHERE criteria. Instead of DLookup better to include fields in combobox RowSource then reference combobox Column index, index begins with 0 so if data is in column 2 the index is 1: =[cboSomething].Column(1).

[erich_18]

Thanks June7. I went with your suggestion and included the fields in coombobox rowsource..etc and now it works fine.