Using a query to fill a form.

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a form that is based on a query. The query uses 2
tables: Customer and CustomerContact. The purpose of the
form is to input data related to monthly contacts. The 2
tables are related by the [CustomerID]. The query design
is:
[CustomerID] from tblCustomerContact (combo box)
[CustomerName] from tblCustomer
[CustomerPhone] from tblCustomer
[Date] from tblCustomerContact
[Comments] from tblCustomerContacts

When I run the query, I am able to add data to all fields.
However, when I try to add a new record in the form, the
[CustomerID] and the [CustomerName] will not fill in. I
have a combo box to select the customerID and name. When
I click on the drop-down arrow, I see all of the
Customers listed. When I select a customer, I hear
a "ding" and the data is not entered.

Thanks for any help!
 
Mike

It isn't clear, from your description, what your underlying table structure
is. If you have a well-normalized design, you'd use a main form to
hold/display the customer information (and a combo box to select a specific
customer), and a subform to show the Contact information related to the
selected customer. To add/edit a Contact, you'd be working in the subform,
after first selecting a customer in the main form.

Or have I misunderstood your situation?
 
Back
Top