Forum Discussion
jonacc
Jul 05, 2023Copper Contributor
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...
George_Hepworth
Jul 06, 2023Silver Contributor
First, where does this "client ID box" appear? Are you referring to a form?
If there is no VBA (script is a very different thing, btw) or macro, that may actually be the problem, but without seeing the object in question (i.e. the form) we have to guess a bit.
Let's start with the initial bit of information needed. Is this on a form? Harun's question is next. Then we need to know where and how this additional client info would be. Is that other controls on a form?
If there is no VBA (script is a very different thing, btw) or macro, that may actually be the problem, but without seeing the object in question (i.e. the form) we have to guess a bit.
Let's start with the initial bit of information needed. Is this on a form? Harun's question is next. Then we need to know where and how this additional client info would be. Is that other controls on a form?
- jonaccJul 06, 2023Copper ContributorI think there used to be a macro and it was deleted. I've looked everything in the database. It's full of personal info so I can't really post it. I replied back to Harun's response with my DLookup.
On the form there's a text input called Unit #. We enter in a number which corresponds to a parking spot assignment in another table. That parking spot would then auto populate in another text box on the form.