Form to search and edit datasets (1 Viewer)

georg7 · Oct 9, 2019

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 · Oct 9, 2019

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 · Oct 9, 2019

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 · Oct 10, 2019

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 · Oct 10, 2019

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

Form to search and edit datasets (1 Viewer)

georg7

Registered User.

isladogs

MVP / VIP

theDBguy

I’m here to help

georg7

Registered User.

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread