From: forest8 on 26 Mar 2010 17:43 Hi there I careated a form which used a field which I have deleted from my database because it wasn't needed. Now everyone I open the database, a missing parameter.value text box keeps popping up. What is the best way to delete this field without this recurring message? Thank you
From: John W. Vinson on 26 Mar 2010 18:48 On Fri, 26 Mar 2010 14:43:01 -0700, forest8 <forest8(a)discussions.microsoft.com> wrote: >Hi there > >I careated a form which used a field which I have deleted from my database >because it wasn't needed. > >Now everyone I open the database, a missing parameter.value text box keeps >popping up. > >What is the best way to delete this field without this recurring message? > >Thank you Open the form in design view, find out where the field is referenced, and remove it. It might be in the form's Recordsource query, or in a Master or Child Link Field, or it might be the control source or in the rowsource of a combo box; you may need to do some digging. -- John W. Vinson [MVP]
From: forest8 on 28 Mar 2010 00:36 Thanks for the directions. I found the problem. "John W. Vinson" wrote: > On Fri, 26 Mar 2010 14:43:01 -0700, forest8 > <forest8(a)discussions.microsoft.com> wrote: > > >Hi there > > > >I careated a form which used a field which I have deleted from my database > >because it wasn't needed. > > > >Now everyone I open the database, a missing parameter.value text box keeps > >popping up. > > > >What is the best way to delete this field without this recurring message? > > > >Thank you > > Open the form in design view, find out where the field is referenced, and > remove it. It might be in the form's Recordsource query, or in a Master or > Child Link Field, or it might be the control source or in the rowsource of a > combo box; you may need to do some digging. > -- > > John W. Vinson [MVP] > . >
|
Pages: 1 Prev: PLEASE HELP: Display results in footer section of a split form Next: nnnn |