Hello all. I am in the process of creating my first form in Access. I have created my query that has all the information that I need. My issue currently is, I have one field in my form that needs to have multiple returns in it. In my query, I have a list of items and the vendor and cost. There are multiple rows in the query for most of the parts, one for each vendor of that item. In my vendor box of the form, I want it to return each unique item, a vendor name and their cost for that part. Each of the other boxes will only need to show its information once, as this information is identical on each row for that part. When i created the form (just using the wizard for now until i figure out how to create one from scratch) it is only showing the first row in each of the sections. In my form, I will need the vendor name and then that vendors cost in a box beside their name. I have an old one that someone else made that is way more complicated than I can figure out which is why I am trying to create a new one that we can keep updated ourselves as the original person no longer works with us. Here is what the old one looks like, the arrow is what I am currently trying to replicate. Thanks for taking the time to look.
Chris