Trying to search and find a record, but it is somehow updating a record incorrectly

[msmithtlh]

I have a table for businesses, which includes an ID field (autonumber), a business category, a name and some other fields. I want the user to select a category in the first combo box. In the second combo box, I want the user to be able to select the business name from all the businesses in the selected category. Then, find the record, displaying the ID field, category, and name.



This seems very straight forward, but everything I have tried does NOT work. The bizarre thing is that it seems to update or create a record, putting the ID number in the name field.

I have tried multiple approaches, none of which are working. I've been working on this for a couple of weeks, and need to get past this and on with the rest of the program.

I stripped out the extraneous objects and have attached the database.

Your help will be greatly appreciated!!!testCAJM.zip

[Welshgasman]

The combos should not be bound.

[June7]

Controls used to input/select filter criteria should be UNBOUND, otherwise data in record is changed - as you have discovered.

[msmithtlh]

I tried using unbound fields, but had problems.

I need the 1st combo box to lookup category value from Buscategories!Buscategory.
I need the 2nd combo box to lookup business name from Businesses!BusinessName where Businesses!BusCategory = value in the 1st combo box.
After the 2nd combo box is selected, I want to display the Businesses!BusinessID field.

Can you give me help with the VBA code? Thanks!!

[June7]

You describe cascading combobox - a common topic.

Do you want to use these comboboxes to filter form records?

Exactly what problems did you have?

I will try to look at your file tonight, if no one else provides solution.

[davegri]

smith-test-davegri-v01.zip

Attached DB is as below changes:



Made changes to schema

[msmithtlh]

Thank you so much!!!!!!!!!!!!