Dlookup

Resolved · High Priority · Version 2003

Fri 26 Sep 2008, 09:59 Delegate Paul said...

Paul has attended:
Access VBA course

Dlookup

I've done lots of dlookups before but don't understand why this one isn't working.

I have a table called tblMonths which contains the fields MonthAndYear (content e.g. "September 2008" in text) and PriorMonth (number - single format, contents e.g. 200809)

This table is used successfully to populate cmbTeam on form frmTeamKPIs.

The dlookup reads:

=DLookUp("[PriorMonth]","[tblMonths]","[MonthAndYear] = " & """ & forms.frmTeamKPIs.cmbMonth & """)

I get a blank field when trying to run.

Can you help??

Thanks
Paul

Fri 26 Sep 2008, 11:24 Trainer Laura said...

RE: Dlookup

Hi Paul

I hope I undersatand your question correctly and that the field MonthAndYear contains text in the same format as cmbMonth on the form.

Building a criteria to look in a text field I would usually use a single quote, ie

=DLookUp("[PriorMonth]","[tblMonths]","[MonthAndYear] = '" & forms.frmTeamKPIs.cmbMonth & "'")

If that doesn't work try doing a debug.print of the criteria to make sure it looks okay.

Let me know how you get on.

Laura

Fri 26 Sep 2008, 22:06 Delegate Paul said...

RE: Dlookup

Thanks very much Laura, I thought it would be something simple...and it was.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips