First Record is Transferring to each Customer

[jkg0679]

I have set up a database using multiple tabs. My customer name field is a drop-down box from which the user can select from any of our customers. Beneath is a subform that provides information about each oof our customer's products in a datasheet. When I switch to a new customer from the "default" customer (the customer that is open when I first open Access), the first record of the "default" customer moves to the new customer (no other records do this, and the new customers products appear along with the other). This one record will conntinue to move to any customer I click on. Any idea why?

[June7]

Is purpose of the dropdown to search/move to a customer record? If so, the control must be UNBOUND, otherwise you are changing value in record, not just entering search value.

[jkg0679]

It needs to be bound as we need to be able to switch between customers and have thir products appear in the subform.

[orange]

Please show a jpg of your tables and relationships. You should be able to zip it and attach.

[June7]

Again, the combobox used as input for search criteria must be UNBOUND. Use textboxes to display the data already in existing record.

[jkg0679]

When I change the Customer combobox to unbound, and I click on a customer's name, their information is not refreshing.

[June7]

Need code behind the combobox to filter the form recordset or to locate and move to the record. Here is one method for the filter approach http://datapigtechnologies.com/flash...tomfilter.html


Options for retrieving and displaying the related customer info:

1. multi-column combobox

2. form RecordSource that joins the two tables, set properties of customer info textboxes to Locked Yes and TabStop No

3. DLookup expression in textbox

[jkg0679]

Awesome! That worked!!!! Thank you so much!