Form: filter and update on filter

[gittymoe]

guys, I am trying to create a form that would allow me to filter a table or query on an ID and display all of the skus associated with that ID and then update a requirement of yes or no. I can get 1 sku to show up but I am having trouble getting more than 1 to come up in the form. This would allow me to update many records instead of just 1 at a time.

It would look at something like below.

ID 1 Sku 123 communication required Y
Sku 456 communication required Y
Sku 789 communication required N
Sku 101 communication required Y
Sku 112 communication required

Any help or direction would be appreciated

Thank You,

 

[Micron]

Not enough info. Maybe the structure of your form is such that it only displays one record and you have navigation buttons? Do you have a query that returns the records you want but they are not showing up in a form based on that query? If yes, maybe you need a continuous form or datasheet form? You can filter a table (to quote you) manually, but I suspect you want to filter the records showing up on a form and not actually filter a table. This takes me back to my query question. If you have that, why isn't that your filter? If you don't have a working query, try the Access query wizard. I presume all the fields you posted exist in your table(s).