Drop downs error on clear

[Ruegen]

If my staff clear the show combo box (press delete on what they have selected)

I get this



I am assuming because they have cleared it and it is null it can't find it

original vba below

ShowPricePerStudent = Nz(DLookup("ShowCostTotal", "tblJncShowYear", "ShowsID=" & Me.ShowsID & " AND ShowYearID=" & Me.BookingYear), " ")
BookingTheatreSeats = Nz(DLookup("ShowTheatreSeats", "tblJncShowYear", "ShowsID=" & Me.ShowsID & " AND ShowYearID=" & Me.BookingYear), " ")

Any suggestions?

[pbaldy]

Sure; test both combos and only run that code if both are populated.

[Ruegen]

Sure; test both combos and only run that code if both are populated.

ok I will give that a go, thanks pbaldy