Dlookup problems (string criteria)

[Everton]

After some playing around further to my question below I have found the problem seems to be that I'm using a string variable as the criteria for the Dlookup function. I assume its a matter of syntax, but how do I use a string variable as criteria in a Dlookup function?

Thanks,
Paul

 

[Rich]

Why can't you just add the country to the combo box?

 

[Everton]

I've actually just this minute found the solution on the Microsoft Knowledge Base. Text criteria have to be enclosed in single quotation marks.

I don't understand what you mean though, by adding the country to the combo box. Maybe I haven't explained the problem very well.

Thanks anyway,
Paul.