I have a database with a form I am working on. On the form I put a combo box that I can use to choose a Law Enforcement agency, then the law enforcement agencies' information would auto populate (address, city, zip, etc.).
Well, this morning I opened up my database that I am working on and made some changes to my form, tested everything out, and was happy with the results. Then I moved fields around (layout changes) and added some fields from another table. Then, when I went in to test my first combo box that I talked about in the first paragraph above, it has all of the information in the combo list selection so that now it just looks ugly when selecting it. Whereas before, it showed JUST the agency name, and it auto populated the rest into the fields. You can see what I mean in the screen shot below in the attachment.
Why is it doing this all of a sudden? Literally, it was working half an hour ago with JUST the agency name. Now, it shows everything in there and I didn't even change anything!!!