Dlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is my code, does anyone know why the dlookup doesn't work

ProjNum returns the value "09879

Code starts here***************************

Private Sub Report_Open(Cancel As Integer
ProjNum = InputBox("Generate an EPS Report for which project number?", "Project Number?"
Me.Text111.ControlSource = "='" & ProjNum & "'
ProdName = DLookup("[Project Name]", "Query1", "[Project Number]=" & ProjNum
Me.Text36.ControlSource = "='" & ProdName & "'

code ends here***********************************
 

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

Dlookup 3
help with conditional statements 1
strSQL with CompletedDate 8
Using MultiSelect List Box to pull records of selected IDs from a report 4
Clear Button does not work 4
Report Group Level On Open - Receiving Error 3
Form from 7.0 to Access 10.0 3
Access DLOOKUP with IF Function in MS ACCESS DB 0

Back
Top