Selective Query Update (Access 2003)

[AGMCon]

Scenario:

Input Query: qry Inventory

I

[HansV]

What do you mean by "I

[AGMCon]

Sorry about that Hans.

In my previous Post: 630,125 you had helped me with the identification of a range of bin numbers. As I mentioned it worked perfectly and I ended up with a filtered query which contained the aforementioned group of bin numbers.

What I

[HansV]

Filtering a form doesn't have any influence on the table or query it is based on. So if you run an update query on that table or query, you will update *all* records in the table or query, not just the ones that have been filtered in the form.

If you still want to know how to update the filtered records: you could use something like this:

Dim strSQL As String
strSQL = "UPDATE [qry Inventory] SET [Inv_Mst_CycleCount] = True WHERE " & Me.Filter
DoCmd.RunSQL strSQL

[AGMCon]

Hans,

Many thanks again. Another arrow in my quiver of Han-inspired coding. That's the good news. The bad news is that sometimes I obviously forget where I put the quiver <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>