Filter table in form by user input

[swavemeisterg]

I have no idea how to do this:



I want to have a form in which a user enters a specific serial number, and all items from the inventory with that serial number appear. I would then like the form to calculate and display the sum of one aspect of all of the items.

Any ideas?

P.S. I'm pretty new to access, but VBA does not scare me

[June7]

Here is one technique for filtering http://datapigtechnologies.com/flash...tomfilter.html

The summary calc can be done on form but reports are better.

Options with form:

1. If form is in Datasheet view can use the Totals button from the ribbon.

2. Expression in textbox in form footer: Sum([field name here])