DLookUp Qury Text Vaule from CBO

[www]

Hello,



I have a Combo box that the criteria is from a query (different mailing dates). When the user selects a date from the combo box, multiple text boxes display data from that dates mailing. What I am trying to get is another text box to display the staff that did the mailing on that date.

I have a query (q_Directive_track_RL_cbo) with the following columns:

Mail_Date	Type	Staff
9/18/2017	Enrollment	WO

When the combo box is set to 9/18/2017 for example, I want a text box to display "WO"

my current code =DLookUp("Staff","q_Directive_track_RL_cbo"), but now I am stuck.

Thanks.

[ranman256]

you don't need a Dlookup...everything is in the combo box.
have the combo show 3 columns,
when the user picks the date, fill in the text boxes from the combo
(NOTE: in vb, columns begin with zero ,not 1)

sub cboBox_afterupdate()
   txtType = cboBox.column(1)
   txtStaff = cboBox.column(2)
end sub

[www]

Thank you.