Form to Update Existing Records

[RCopeland]

I am developing a database for a friend to track his inventory of fishing equipment. In this database, there is a table called "Bait." This table holds records for each bait he owns and includes a field called "Quantity" that indicates how many he has of said bait. There is currently a form that allows him to add new bait to this table and it works fine.

The problem I have is that when he goes to the lake and loses a bait, or goes to the store and buys duplicates of the same bait, he needs to be able to edit the quantity within a particular bait record. I would prefer to do this using a form.

The first thing I tried was to create a query for baits with quantity that equal "0." Then create a form based off that query so that he doesn't have to search through many, many bait records to find the exact one he needs to edit. I have a vision of a form that includes each bait in the query to appear in a combo box. When a bait is selected from the drop box, he has the ability to add or subtract a particular amount from the quantity field. Then press a button to update the record and re-query so that the bait he just edited disappears from the combo box in the form. Any ideas?

 

[VilaRestal]

Why not just have a continuous form (or even datasheet) that just shows bait and quantity?
Finding a bait in that will be easier than finding in a combobox. It wouldn't be hard to add a Search textbox to the form and/or a switchable quantity = 0 or > 0 filter to help with that process.

 

[RCopeland]

Okay, so would you suggest that I use a query as the beginning of form or forget the query and simply use the table bait?

 

[VilaRestal]

May as well use the table bait. You can filter it (or change the record source to select * from Baits where...) at a later date if need be.