*URGENT HELP NEEDED* DLookUp Formula

[iProRyan]

Hi Guys,



I am in need of urgent assistance tonight, and tomorrow morning if possible, the first issue is with a DLookUp formula.

What I need is for it to say "[The DVD Title Text Box] = The DVD Title from the DVDs Table when the DVD ID = [The DVDs ID Text Box on Form]

I have a tried a variety of things and always get ?Error or ?Name this is what I have at the moment

=DLookUp("DVD Title","DVDs","[DVDs]![DVDID]=[DVDsID]")

Just to check, this is meant to go in the Control Source of the DVD Title Text Box on the form.

Thanks,

Ryan.

[Robeen]

Try this:

DLookup("[DVD Title]", "DVDs", "DVDID = '" & Me.DVDsID & "'")

Let me know if that works.