Thanks for your suggestions. That does enable me to populate boxes besides just the first and second columns from the query, although the result is not ideal. I don't understand why it is not necessary to define more than one column to get the second column in the query to populate in a text...
I'm trying to fill out a few fields on my form based on the value selected in my ComboBox. I have a query that selects 4 fields. Column1(subscript 0) of the query is used in the drop down box.
The second column (subscript 1) will populate into Text boxes on the form, but columns 3 and 4 will...
Hello There.
I have signed up because I've finally decided to go beyond creating tables and writing queries. And, of course, I got stuck immediately and decided I could use some help.
I've been messing around with Access databases for about a dozen years now, but kept it basic.
I'm a soccer...