help with form, query, and table (1 Viewer)

[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.

 

[Uncle Gizmo]

The simplest way to achieve the functionality you want would be to use the auto form wizard to create a form based on the table you describe, then with this form open, select " filter by form" fill in your filter criteria and this should find the record you want.

 

[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.