DLookup error: Data mismatch

V

VBAgroupie

I have tried everything to get dlookup to work. Can anyone give me any ideas
what to look for. I've tried converting the strings to numeric/currency,
etc. I'm trying to return the currency value associated with a field on the
screen. I don't know what else to try. Any help is appreciated.
 
K

Ken Snell [MVP]

Hard to give suggestions without example of what you've tried....
Please provide more details.
 
F

fredg

I have tried everything to get dlookup to work. Can anyone give me any ideas
what to look for. I've tried converting the strings to numeric/currency,
etc. I'm trying to return the currency value associated with a field on the
screen. I don't know what else to try. Any help is appreciated.
Click to expand...

Have you looked in VBA help?
My crystal ball is down for maintenance today.
Any reason you haven't posted what you have tried, along with the
field datatypes, so that we can tailor a reply to your needs, rather
than give you a generic reply that you may already have used?
 
Top