Combobox and data entry text box

[zmbaker]

I have created a form with a combo box that pulls records from a table. Then I have a text box to enter that name of the company to be entered with the matching record. And a save button to save the event.

Instead of my combo box and text box updating the record, it update the first record in the table instead of finding the record that matches the combo box. Any ideas what I did wrong?

[ranman256]

Is sounds like you have the FORM connected to a table. (it always starts a rec#1)

Remove the data source from the form, then when you pick the cbo and text fields, run an update query with these values.

[rpeare]

why would you need two controls (text box and combo box)

Assuming you have a primary key (let's say a customer table with a customerID (autonumber) and a customer name).

If you are using a bound form you can create a combo box that is bound to the customer ID field of your target table (customer orders perhaps) and set the combo box to have two columns, Customer ID and CUstomer name, then set the widths to 0,2 (for example) The customer name will appear in the combo box and the actual data stored would be the customer ID.

If you are trying to use the combo box to search for records relevant to a specific choice that's a different matter but I'm not entirely sure I've understood your post.

[zmbaker]

I have another database that has a table as the record source that updates the specific record though, I just cant seem to get this one to do the same thing

[rpeare]

perhaps if you provide a sample database we can take a look at it.

[zmbaker]

The combo box searches for a records for a specific choice then the text box updates the name field in the table. For example the combo box has categories and I have a user to reviews the categories but it isnt necessarily in order so the combobox find the record then the text box records who reviewed the category.

[rpeare]

so why not provide a cascading combo box, so when the user changes the choice in the first combo box, a list of valid categories for that selection appears in the second combo box, then, assuming this narrows your search to 1 record you wouldn't have to navigate to a specific record at all.

[zmbaker]

Example.zip

Here is the example i have

[zmbaker]

How do you create a cascading combo box? The other problem would be I still need the date associated with the change

[zmbaker]

I solved the issue i just created a searchforrecord macro

[rpeare]

all you need to do is in the ON CHANGE event of your combo box click the the expression builder (three dots on the far right of the row), create some code (one of the options)

type in: me.requery

whenever you chagne the selection of the combo box the relevant record will be brought up.