I am building a form based on a query. I have the query built, to return certain data, qryapplication10withstaff. I also have a separate table, tblbasestaffsummary,that I cannot link to in the query, no one to one relationship or any relationship. The query calculates the weekday, time and date from a crazy nom date the software that I am querying assigns.
I have the form built with the query now I would like to pull data from my other table into the form based on criteria in the form.
I tried dlookup function but cannot seem to get it to work:
=dlookup("[staff]","[tblbasestaffsummary]","[weekday]= forms![weekday]" and "[time]= forms![time]")
I should have also stated that this is a continuous form. It list data per day from 00:00 to 23:30, in half hour periods. I think subforms can only go into single view forms. This is why I am attempting the dlookup.