I have the a combo box that looks up the Location ID -They can chose a location from the drop down or begin typing and it self populates.
The problem is that there is over 150 Locations and they have trouble remember what city they are in.
I did remove the quotes because it is a number field...
The Location ID Field is the Primary Key in the table and is an auto number field.
When I tried using the command it gave me a syntax error that said there is either text without quotes or I am missing an operator.
Would something like this work better if it were written in a Macro and then...
I have this command set up in the After Update Field of the Location ID on my Data Entry Form. I want it to go back to the City Table, Grab the City Name based on what is entered for a Location ID on the form and input that in the City Name Field on the same form.
Am I putting this command in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.