Access search result will be able to be updated

[Jack]

Hi,
I need to create a form in Access that will search few fields and based on
the condition will produce the search result in datasheet like result.
However, the result set need to be able to be updated. Is this possible? I
had created a search form some time back where the datasheet result could not
be updated. Any help is highly appreciated. Thanks.

 

[Jeanette Cunningham]

Hi Jack,
the datasheet will show the results matching the user's selection in the
search combos as read only.
To edit the results of the user's selection, instead of showing the results
on the search form,
open a new form in datasheet view with a filter or where clause matching the
user's selection, open as allow edits.

Jeanette Cunningham

 

[Jack]

Thanks for your reply Jeanette. I appreciate it.
Is there any reference on the web with the method you are suggesting?
Best Regards

 

[Jeanette Cunningham]

Jack,
have a look at the search form on http://www.allenbrowne.com/ser-62.html

Jeanette Cunningham

 

[Jack]

Thanks a lot Jeanette. I appreciate it.

Jack,
have a look at the search form on http://www.allenbrowne.com/ser-62.html

Jeanette Cunningham