Form to Update Records - Include a filtering feature

[J. B.]

Hi all,

I currently have a form called frmCommunication in Access that lets the user
add records to a table called tblCommunication. The form consists of the
following fields:
Date
Cust_ID(Combo Box)
Contact_ID
Issue_ID(Combo Box)
Notes
Incoming(Yes/No)
Outgoing(Yes/No)
Visit(Yes/No)
Email(Yes/No)
Phone(Yes/No)
Survey(Yes/No)
A subform to display contacts for a specific customer. This subform is a
based on a query that displayes the Customer's Contacts based on combo box
value of the Customer. The form has FNAME, LNAME, and Contact_ID. The user
enters the Contact_ID of a the person they are communicating with.
A subform that displays the Survey information. It queries a table called
tblSurvey based on the Cust_ID field to display when the last survey was
conducted and when the next survey will be issued.

I have a table structure as follows:
tblCustomer one to many relationship with tblContact
tblSurvey has a one to many relationship with tblCustomer
tblCommunication (where the info is stored from the form) is the result of a
many to many relationship between the the tblContact table and the tblIssue
table.

I would like to create a combo box that would allow the user to select a
Customer Name (query the tblCustomer table) and filter the records shown in
the frmCommunication form. I then would like the user to be able to edit
the different fields. I can create a parameter query that will prompt for
the Customer Name and then display the records from the tblCommunication
table but I am unable to update the info.

Any help would be much appreciated!

Thanks in advance,

J. B.