Access search result will be able to be updated

  • Thread starter Thread starter Jack
  • Start date Start date
J

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.
 
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
 
Thanks for your reply Jeanette. I appreciate it.
Is there any reference on the web with the method you are suggesting?
Best Regards
 
Back
Top