help with form, query, and table

[JahJr]

I have a table with 4 columns.
ID
Date
Category
Product
Price

The table has information in the first 4 Columns.

I need a user form where you can select a particular; Date, Category, & Product from the table. Then have a text box where you can enter a Price.

There will be a Command button that when clicked will add the price to the table in only the rows where Date, Category, & Product match what was selected in the user form.

I can build the form but I have no idea how to make the form enter the price in the correct rows.

Any help or direction will be greatly appreciated.

 

[JahJr]

I played around with the filter by form and it looks like it would possibly work, but I need to create a form that will be simple to use as this operation will be used alot. I have been reading somemore and I believe I might be able to use a update query but not exactly sure how.