MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to edit the data in form?

  Asked By: Sue    Date: Feb 20    Category: MS Office    Views: 709

I have created a form with command buttom (named ADD). Here whatever I add the
information it is storing in another sheet which is basically hidden. The
problem is that if I enter anything wrong then i have to unhide the sheet and
change the required cell.

I want to know if there is any VBcode which identify the wrong data
from stored data and then edit the cell at any point of time? Similarly If
I want to delete entire row then i should do it without unhiding the sheet.
[Note: without unhiding the sheet where the data are stored]



1 Answer Found

Answer #1    Answered By: Aabirah Khan     Answered On: Feb 20

If you don't want to go and fix the data  in the hidden  sheet, you will need
to add edit  or fix functionality to your form. Nicest would be to simply
allow the record to be reopened in the form  and then change the add  to Save
or OK.

I don't know what you mean by "identify" wrong  data. You should be
validating the fields before you store them - that's just normal programming
practice. But what constitutes "wrong data" - anything from simple
misspellings to typing in something associated with a different record by
mistake. No program will be able to catch these - you will need the edit or
fix facility.

Didn't find what you were looking for? Find more on How to edit the data in form? Or get search suggestion and latest updates.