I have a huge problem with MS Access. I am trying to develop something that uses databases, but isn't data entry. Currently I have a list box that has several columuns/rows populated with dates and locations. I also have a two combo boxes, both filled with peoples names. Both the combo and list boxes are tied to tables that are imported from excel. I need to be able to click on a row in the list box, and click on a person's name from each combo box and then it appear on another data sheet (all of them at the same time, not just show one record). Ideally I would like this to be done with the click of a button. I have tried to make the new datasheet a subform and can't get the information from the list box/combo boxes to the new form. Any ideas?

What do you want to do with the data once you get it where you want it?

You would not use a subform for this, but could post the data to a text box, or several text boxes. Then if you wanted to process them further, you could then push them where ever you needed them to go.

If you want to use a datasheet for a subform, you will need to create a table to hold the data, then push the data to the table and requery the subform with the button click.

HTH

mmcdonal