Help!!! DLookup returning #Error (1 Viewer)

[NoviceBoy]

Hi Bob,

Here's the db with the offending table / field. Please let me know if you can't access anything, as it's been chopped to death.

 

[boblarson]

Boy, don't know how you ended up with what you had in there but it sure wasn't close to what I had. The main problem is that your combo box, while showing the name had the ID as the bound column. This is GOOD but you have to use IT instead of the description.

So this is the correct statement to use (tested) and you do not want to have the DEFAULT field filled in with whatever you had there. It does no good if the control source is bound to a function like you have with the DLookup.

=DLookUp("AcqCosts","CSL_Agreed_Costs","[ID]=" & [AgreedCostType])

 

[NoviceBoy]

Bob,

Tried and tested. You're a gentleman Sir. Many thanks for your help. Don't know where you are, but if you're ever in town, it's on me (town top right).

Know anywhere I can get some hair grow cream?

 

[boblarson]

I'm in Portland, Oregon, USA and not likely to ever get over there. I hate traveling on planes, especially anything longer than going to Hawaii (5 hours). But thanks for the thought.

As for hair cream - I think you want a prescription strength version of Minoxydyl (however it is spelled).

 

[NoviceBoy]

You never know Bob. The Grand National comes up every year, and we have the closest house to the course. Seriously, many thanks. Can we talk offline, as there are many other issues we have which need resolving. A lot of them I can sort myself, but we need some advice, and don't expect it for nothing.