I have a form that draws most of it's data from a sharable access database.
Unfortunately some of the fields aren't completely updated. Therefore I am
looking for a way to edit the cell that the formula(index etc...) is found
in, in the event that the data retrieved isn't current.

Example: the form has a field for SSN, which I have placed a list box, and
the other fields such as last name, first etc are populated once the correct
ssn is selected. The problem is that sometimes the ssn that I am searching
for might not be there, so that would mean that I would have to enter the
correct information and in the corresponding cells that use index. I don't
want to destroy the formulae that are in them.

Thankyou.