In the Following Code I am wanting to change the control source to the DLookup
my problem is because in the code the 'WkEnd', 'qryQtyNeed' need to be in double quotes.
but it wont let me code double quotes within double quotes.
how can I get this to work?
Is there a way to use a query as the controlsource without the dlookup?
Code:
Dim WkEnd As String
Dim WkDay As String
WkEnd = "=DLookup('WkEnd', 'qryQtyNeed')"
WkDay = "=DLookup('WkDay', 'qryQtyNeed')"
Me.listEmp.Requery
If Me.txtDayNo >= 6 Then
Me.txtneeded.ControlSource = WkEnd
Else
Me.txtneeded.ControlSource = WkDay
End If