I need to compare data from multiple lines of data against each other on a form

[mcronin]

Hi,

I want multiple records to show up on one form page by using a key, can this be done? I have a lot of lines of data and a lot of them have the same company attached to them so I created a company id hoping that would allow me to bring up all the data from each of those lines next to each other in a nice form. I have attached a picture of the format that I want the data to pull into which it does obviously but I want to make it so that all of the lines of data that I have chosen that have the same company ID show up next to each other on the form. Can someone help with this?



Thanks in advance!

[ranman256]

the form is connected to a query that uses the key you picked out of a combo box (or textbox) on the form header.

Qry=select * from table where [id] = forms!myform!cboBox

in the combo box afterupdate event, refresh the list

sub cboBox_afterupdate()
  me.requery
end sub