I need to display information from 1 table in a form and subform. I am using all fields from the table, "tblCallData" in the mainform, and then in the subform, displaying all of the data in the notes field, that match the customer ID.

How can i do this?

Create a query based on the the customer ID and the notes field. Then use the query to populate your subform, and then link the child and parent fields on customer ID.

Did that help?


mmcdonal

Thanks for that. Sometimes just the simpliest things go un-noticed.