Form for Editing the Quantity Value for Existing Records

[RCopeland]

Hello All,

I have a database with a main table tbl_Inventory. This table has fields:

Inventory_ID
Model
Maker
Category
Type
Quantity

I have a form for editing the quantity of broken or lost Inventory Items. This form consists of three combo boxes in which the selection adds criteria for a Query (qry_Inventory) so users can search records in a listbox by Maker, Category, and Type. Once they manipulate the combo boxes and select a record from the listbox, the Quantity shows up in a textbox.

The idea was to allow users to then change the Quantity value for the selected record and update the record by clicking a save button.

The first thing that I tried was to populate the listbox from the qry_Inventory, but the problem that I ran into is that the value in the textbox for Quantity cannot be changed or edited.

Then I thought that I should link the listbox directly to the tbl_Inventory and use the comboboxes as filters of some sort, but I cannot seem to figure out exactly how to apply these filters. On top of that, when I use the table rather than the query to populate my listbox, I am unable to select the records within the listbox in order to populate the textbox Quantity.

Am I on the right track? What am I doing wrong? Any advice would be greatly appreciated! And I am not so comfortable with VBA, so if there is anyway to do this using macros and/or expressions, I would be extremely happy...

 

[spikepl]

allow users to then change the Quantity value for the selected record

What is this inventory table? Is this for stocktaking, or is this to be an operational item? If you intend to let ppl directly change what you have, then think of a bank account. You don't let anyone directly change the total held in the account, but record in/out-transactions, and tally up to get the remaining total.

 

[RCopeland]

It is an inventory system for a professional fisherman, so that he can manage his rods, reels, and specific bait items. The usage of this particular form is for when he comes home from a tournament or any practice fishing before a tournament to be able to select an item that he may have lost or broken during the day, then reduce the quantity. This would allow him to decide if he needs to buy more, or not.

 

[CMD]

I am in a similar situation. I have an estimated list of materials, I would like to be able to create a form that shows the list of materials and the user can then edit the list (ie. material, quantity, etc.) to create a Purchase Order, this would then populate my inventory. I am stuck on how to build a form that starts as a query but can be edited. Any help would be appreciated. Thanks!