Forum Discussion
Moved old Access DB to latest Access and small issue
I have an Access DB that we use to store client info. On older versions of Access when I looked up a client, some of the client info would automatically populate when I tabbed out of the client ID bo...
Harun24HR The ID box is a text input field. This is what I made but won't save, and doesn't seem have a syntax error.
=DLookUp("Space #","Parking Space","Unit #=" & "Unit #")
Unit # is the apartment we used to enter and hit tab.
Parking Space is the table that the Space # comes from referenced to the Unit #
I've said it so many times I'm sick of it, but I will say it one more time: do not use spaces or other funny characters in object names. They may cause notational difficulties.
As they do in your case. Your DLookup statement needs [some work].
As they do in your case. Your DLookup statement needs [some work].