Update data in a table via a form

[SeanA]

That does help some. The only thing is, I want them to be able select just a REG value and it show (inside of the form) all service bulletins for that REG (would show multiple rows of data). So, they do not have to edit then if they do not want to. I then want them to be able to select a value for ServiceBulletin (after selecting a REG), and it re-filter for the two seperate criteria (leaving 1 row of data). After that they can hit a Close button that prompts with "Would you like to save your changes?". The save button works fine and the REG filter works fine. What I can't get to work is the subsequent filter with ServiceBulletin. I have got it to work where both REG and ServiceBulletin are filters, but when I do this it will not show values until both have been selected.

[June7]

Haven't we been discussing an UPDATE query?

Now you are talking about just filtering the form Recordset? For one method review:
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...earchform.html

[SeanA]

Yes, but I posted (after you suggested I switch to a form with a datasheet view) that I wanted to be able to filter and then update. Sorry, I'm trying all of our suggestions as they come though. I'll look at those two links and let you know how things are going.