Dlookup Date problem

A

adriany

txtbox2 = DLookup("[field1]", "table1", "[field2]= '" &
[field2] & "'")

when field1 is text this code works fine
when field1 is date is not working at all.

can anyone help me with this one
 
G

Gerald Stanley

Try
txtbox2 = DLookup("[field1]", "table1", "[field2]= #" &
Format([field2], 'mm/dd/yy') & "#")

Hope This Helps
Gerald Stanley MCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 options based on result 4
updated field 5
validation rule (for a record in a table) with dlookup 7
expression in SQL works in control property but not in VBA 4
Different fields "Required" 1
DLookup in Continuous form 0
Change text colour in Report based on condition 3
Parsing Month WorkSheet (one row/Project) into Folder & SubFolders by Project 0

Top