Using forms to immediately edit/update a table

[June7]

You just have to include all three criteria. Options:



1. query with parameters as demonstrated in http://datapigtechnologies.com/flash...tomfilter.html

2. code (VBA or macro) to move to record

3. code (VBA or macro) to set form Filter and FilterOn properties

[TKTheKid]

Thanks June. I got that part now. However, there's one thing I overlooked:

I need the source of comboArticle to be based on both the value of comboTicket AND comboLocation. So I tried to change my comboLocation_AfterUpdate procedure to:

Private Sub comboLocation_AfterUpdate()

comboArticle.RowSource = "Select DISTINCT tableWarehouseData.Article " & _
"FROM tableWarehouseData " & _
"WHERE tableWarehouseData.Loc = '" & comboLocation.Value & "' " & _
"WHERE tableWarehouseData.Ticket = " & comboTicket.Value & " " & _
"ORDER BY tableWarehouseData.Article;"
End Sub

However, I get an error as soon as I click on the comboArticle combobox that says:

"Syntax error (missing operator) in query expression 'tableWarehouseData.Loc = 'z' WHERE tableWarehouseData.Ticket = 8'."

What's wrong? I'm guessing that it's probably something really simple, haha. Can you please take a look at form formWarehouseData again?

Thank you once again!

Tony

[June7]

comboArticle.RowSource = "SELECT Article FROM tableWarehouseData " & _
"WHERE Loc = '" & comboLocation & "' AND Ticket = " & comboTicket & " ORDER BY Article;"

[TKTheKid]

Perfect! Thanks June!