Thanks to both of you for your suggestions.
I believe that the problem was all along that the form fields did not match
EXACTLY the database fields. There is a flaw in FP as you can have a normal
submission form where you can enter the data, submit te data, get a
Submission Confirmation(!!!) and yet the database is NOT updated. Apparently
(and it was so in my case) error messages do not always appear when the
fields do not match exactly from the form to the database. It will just not
tell you! This is especially bad as fields are added without the users
knowledge.
I resolved my case with the following steps:
1. completely recreating my database from scratch, importing it into the
site and creating a connection
2. I created a submission form to this database using the Database Interface
Wizard thus insuring matching fields. I also removed all the fields created
by FP (or access?) and that were NOT in the original database
3. I replaced (thanks crash!) the fields that I wanted with a drop down list
(inserting a database results form) and named these drop down lists the SAME
name as the original fields I replaced.
Voila! it works!
Thanks for your input
Ed
"Rob Giordano (Crash Gordon®)" wrote:
> Instead of changing it to a drop down, try adding a dropdown (new field)...see if that works.
>
>
> "EdH" <(E-Mail Removed)> wrote in message news:2F2EA8CD-B8E9-42AA-A955-(E-Mail Removed)...
> > OK, thanks.
> >
> > Follow up: DIW submission form works fine, but I want to change one of the
> > fields to be a drop down list. If I do that, the form does NOT feed the
> > database. No errors are reported. It just does not add any data. I tried
> > updating the database and fields seem to match between the form and the
> > dbase, but no luck. Any suggestions?
> >
> > FYI the submission form is created from an existing database connection
> > which I created. Again, with no modifications the form feeds the data. If I
> > change one field it stops updating.
> >
> > Thanks again,
> > EdH
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> > > You can disable these items under form properties, saved fields.
> > >
> > > --
> > > ==============================================
> > > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > > WebMaster Resources(tm)
> > > http://www.ycoln-resources.com
> > > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > > ==============================================
> > > If you feel your current issue is a results of installing
> > > a Service Pack or security update, please contact
> > > Microsoft Product Support Services:
> > > http://support.microsoft.com
> > > If the problem can be shown to have been caused by a
> > > security update, then there is usually no charge for the call.
> > > ==============================================
> > >
> > > "EdH" <(E-Mail Removed)> wrote in message
> > > news:90DCF043-5FF2-4152-8885-(E-Mail Removed)...
> > > > The DIW it generates a Submission Form which includes fields that I do not
> > > > want the users to fill in - like timestamp and UserID. Can I just delete them
> > > > from the submission form without creating trouble in the entry of data to the
> > > > database?
> > > >
> > > > Thanks,
> > > > EdH
> > >
> > >
> > >
>
Similar Threads
