Dlookup question (97)

Topic

New Reply

The following dlookup complains that my criteria is incorrect & doesn

Reply | Quote

Replies

Hi,
Try changing your expression to:
Me.Text106 = DLookup(“blendpercentage”, “blendpercentages”, “month=‘” & Choose(month(Date), “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”) & “‘“)
As you’re returning a string from your choose function, you need to enclose it in quotes in the criteria string.
Hope that helps.

Reply | Quote

thanks it worked! now i’m working on the 2nd half of my thread.

Reply | Quote

Sorry – I overlooked that bit.
Try:
Me.Text106 = DLookup(“blendpercentage”, “blendpercentages”, “month='” & Choose(month(Date), “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”) & “‘ And type = ‘OA'”)*Me!Text101
Hope that helps.

Reply | Quote

thank you!

Reply | Quote