I have an order form with db lookup combo box that has a where clause to bring up active dealers.
The lookup works fine except for one thing. When I am viewing an existing order with an inactive dealer, the displayed dealer name in the combo box is blank because they are inactive. I can put a box above it with the dealer name but that sort defeats the purpose of the db lookup combo box. Has anybody found a workaround for this issue? TIA Dan Goldberg
