# Error displayed in Text Field

[willfrank]

How do I keep text field clear (no #Error display) until dlookup is activated from combo box selection: Below is my current dlookup code:

=DLookUp("PhoneNumber","Rooms","RoomID=" & [RoomID])

[ranman256]

keep txtbox unbound until you pick the roomID
then just fill in the phone in the afterupdate of the combo.
(and bind it too if needed)

[willfrank]

Thanks for your reply, but this will not work, as the dlookup text field is based on a cascading combo box with a query..

keep txtbox unbound until you pick the roomID
then just fill in the phone in the afterupdate of the combo.
(and bind it too if needed)

[Bob Fitz]

Perhaps:
=DLookUp("PhoneNumber","Rooms","RoomID=" & Nz([RoomID],0))

[ranman256]

then instead of Dlookup, put the phone in a column in the combo box when user selects that item.

[willfrank]

thanks for your suggestion:

I have another resolve that I just received.

then instead of Dlookup, put the phone in a column in the combo box when user selects that item.