unbound field to drive query

[irunergoiam]

I've got an unbound field, unbReq, that I would like to have another unbound field "look at" (call it unbCreateDate) so that, based on the req that is in the unbReq field, a query would pull in the date in the unbCreateDate field. I can build the query and restrict the Criteria to the form...unbReq field. My question is how do I get the unbCreateDate to pull the date field in that's associated with that req/query?

Much thanks to anyone far wiser than me!!

 

[gemma-the-husky]

is it on a form?

in your query use the form control with the reference


forms!formname!controlname

 

[irunergoiam]

It is on a form and I am using the form control reference [Forms]![frmNewHireLegalNameVerification]![unbReq]. The problem I'm having is getting the corresponding date from the query to show up in the unbCreateDate unbound field on the same form.