Update Record using Combo Box To Navigate

[bstboy]

Hello

I currently have a table with three fields (Brand, Service, Inventory).

Brand is a primary key, it can only show in the table once. However, I'll need users to go into the table and update the service and inventory numbers every month.

What I envision is a form in which Brand is a combo box, the user can pick their brands and then the Service and Inventory fields change to whatever in in the table currently. The users can then update those values, hit a button, and the changes are stored in the table.

I've already tried doing this and what happens is on the first record, I try changing the brand, and the first records brand changes to the one I picked and it is saved in the table (like I need to make brand a locked field).

Any help is appreciated.

Thanks

 

[HiTechCoach]

Hello

I currently have a table with three fields (Brand, Service, Inventory).

Brand is a primary key, it can only show in the table once. However, I'll need users to go into the table and update the service and inventory numbers every month.

What I envision is a form in which Brand is a combo box, the user can pick their brands and then the Service and Inventory fields change to whatever in in the table currently. The users can then update those values, hit a button, and the changes are stored in the table.

I've already tried doing this and what happens is on the first record, I try changing the brand, and the first records brand changes to the one I picked and it is saved in the table (like I need to make brand a locked field).

Any help is appreciated.

Thanks

What I would recommend is placing the search combo box in the form's header. This combo box is not bound to any field in the table.

If you use th3 control wizard for the combo box you can select the option to create a combo box that searches.