Dlookup works on all forms, except one.

[NeoPa]

Phil's right JillyWilly. That happens mostly when copying and pasting controls. At least it does with VBA. You mention macros rather than VBA so it may be different for you. OTOH it may be that you confuse one with the other. Very understandable, as it seems they are the same everywhere but in Access. In Access macros are not VBA code.

If you just copied the database as a whole, as you indicated, then that won't happen. I'm wondering exactly what you did do.

I'd like to help more, but at this stage there is a great deal that isn't clear. It can be hard to describe things so that people can understand clearly even though they don't have access to what's in front of you.

[NeoPa]

BTW Phil.
If you have that problem when cutting and pasting controls around within the same form, then copying and pasting the module code over itself generally fixes them all up again for you very quickly. Just a little tip that I've had to discover as that happens to me a lot.

[PhilOfWalton]

Well I've only been messing around with Access for 23 years, and I never knew that. Great tip - Thanks

Phil

[NeoPa]

It's especially sweet when I can help someone of your level of experience Phil :-)

I noticed that when I moved a procedure from one part of the module to another (Cut / Paste), that the property would reset and then set again after I pasted it back (I like my procedures to be in an order that reflects the positions of their related controls on the form). Once I realised that, I figured I might have a solution to the loss of the property whenever I had to move controls via Cut & Paste (As when moving onto, or off, a Tab-Control Page). I'd had to do a number of these and was frustrated by having to check and reset all the event properties by double-clicking on them all one-by-one.

[jillywilly143]

If the Dlookup works on the copy, but not the original, does that mean that something in one of my events is causing the error?

[jillywilly143]

I was able to fix it by Analyzing Performance. It said there was a module running in the background. Thank you all so much!

[NeoPa]

Hi JillyWilly.

Thank you for selecting my post as the Best Answer. However, I must deselect it as it won't give someone with a similar problem the answer directly.

I appreciate that I was able to help, in both senses of the word, but in this case, though I hope my posts were helpful, they aren't something that points anyone else to the answer.

Well done to you for getting to the bottom of your problem anyway :-)