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])
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])
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)
Perhaps:
=DLookUp("PhoneNumber","Rooms","RoomID=" & Nz([RoomID],0))
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
then instead of Dlookup, put the phone in a column in the combo box when user selects that item.