troubleshooting Question

Query Ouput

Avatar of Tanus Sacin
Tanus SacinFlag for United States of America asked on
Microsoft AccessSQL
2 Comments1 Solution424 ViewsLast Modified:
hello all,

I have a very simple MS Access 2010 database and I have table that is call "code", this table have 5 fields:
Code1
Code2
Code3
Code4
Code5

Each of them have a differente values for example, Code1 is that one that have the code number, Code2 have the name, Code3 the address, code4 the city code5 the zip code.

so I have a query where I can search by Code1 and I get all the results, my problem is, how can i put my result on a form, what i need is from a form the user selecting the Code (Code1) and it wil automatically populate the other 4 (code2 thru code5) and the information will need to be save into a table.

any ideaS?

thanks!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros