Form to search and edit datasets

[georg7]

Hello again,
I want to build a form that is like a query but I can edit the queried data sets. Should be like: type in the ID of the product you want to edit. Shows me every product with the ID and I can edit the price of the product.

Any ideads?

Best regards
Georg

 

[isladogs]

That's a standard Access form. Use a combo or listbox if you want users to select from existing record rather than guess the numbers.
Here's an example that may help http://allenbrowne.com/ser-62.html

 

[theDBguy]

Hi Georg. As Colin said, there are a few samples and demos showing how to do something like this, because there are a few ways it can be done. Have you tried any of them?

 

[georg7]

Hi guys,
I couldn't find something like what I'm searching. I think it's not possible.
The searching Option is working but I can't edit the results. So it isn't useful for me.

Best regards
Georg

 

[isladogs]

Assuming your description in post 1 is correct, its certainly possible. In fact as I stated, its a standard use of an Access form.
Here's another example that may be helpful http://www.mendipdatasystems.co.uk/multiple-group-filter/4594454290

With respect to the editing part, there are many reasons why dataset can be read only. Here's a good summary http://allenbrowne.com/ser-61.html. As long as none of those reasons apply it will be editable.
If it helps, post the sql for your form record source