Create a form that edits a specific record

[winteram]

I have a split database and I want to create a form on the front end that allows a user to go in and change a specific record. However, I have 200 records in the database, so a combobox is not realistic. Is there a way to find a specific record without a) scrolling through all of the records or b) using a combo box?

Thank you for your help!!

[pbaldy]

If the user will know how to identify it, they can enter a value into a textbox and you can use the same code to find the record. I might still use a combo, as the user can type into it and it can go to that part of the list.

[winteram]

Thank you for the quick reply. I tried using a combo box but anytime the user types in the specific number they want, the information for the correct record shows up, but any edits are still only made to the first record in the database?

[pbaldy]

Does the information from the desired record fill in the whole form, or just the combo? There should be code in the after update event of the combo that navigates the form to the chosen record.

[winteram]

It should fill in the whole form. The user should know a certain bin number, that will be unique to each record. However, it is not the primary key, due to some issues I ran into early in the development of the database. Instead, I have an autonumber as the primary key. On the form I have the bin number, the primary key field, and a checkbox pertaining to information about the item. The purpose of this form is to allow the user to "check" or "uncheck" certain items. This should be reflected in the table after the user edits a specific record. Did I make any sense there?

[pbaldy]

I know it should fill in the whole form; does it? Can you post the db here?

[winteram]

I can't post the database, unfortunately. But it's not updating the rest of the form correctly. It just increments the id by one and then displays the status of the checkbox for that particular id, even though that is not the correct id.

[pbaldy]

What code if any is behind the combo? You might try using the combo box wizard to add another combo, making sure to choose the third option, "Find a record...". Then delete the existing combo.

[refryguy]

Is there are unique identifier for each record? For example what are you using for the Primary Key?

[pbaldy]

That's in post 5.

[winteram]

pbaldy: There is no code behind it. I recreated it using the combo wizard and used the third option. It now will work correctly only if the user types in the number or selects it from the list and then moves their cursor to a different box in the form. If the user presses tab when they find what they are looking for, it increments the id field by one and displays the checkbox status for the id number, even though the correct bin number is still displayed in the combo box.

refryguy: There is a unique identifier, named simply ID, because it means nothing. It is set to autonumber and its only purpose is to serve as the primary key. Each record will have a unique bin number, but it was causing an issue so I created a generic ID field.

Thank you guys for your continued help.