ACCESS'97 Forms going non-editable

  • Thread starter Thread starter VernDeGeus
  • Start date Start date
V

VernDeGeus

Hi:
have encountered the bedeviling subject issue on a few
occasions:

Seems when adding functionality to an existing, moderately
complex editable Form (representing an underlying
updateable rowsource) that the Form goes "non-updateable";

once this happens there seems no recourse; stripping the
code/controls back to a former state does not help; the
Form is trashed at that point.

Am i missing something fundamental here ?

plse advise
thank you
 
A form becomes non-updatable when you change the Record Source to a
non-updatable query. It should revert to updatable if you fix the query.
Do you have an example of a form that has behaved this way? If so, what is
the SQL of the Record Source?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top