Form submit question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With DRW I created a form from the following statement
update data set
projdesc='::projdesc::',
part='::part::',
projentry='::projentry::',
projact='::projact::',
where projgen='::projgen::'
Can I get the form only to update the database when information is typed
into a particular field. Now if I wanted to update the part field I would
have to fill in the rest of the fields before hitting submit or the database
record would be blank for those other fields.
Maybe there is a smarter way to do this

Thanks, for the help
-Greg
 
What you should be doing is populating the form fields with the existing record values and then editing that form
- that way fields not changed will get written back as they were

You should use the DIW, not just the DRW
See http://support.microsoft.com/default.aspx?scid=kb;en-us;825502 and
http://www.frontpagehowto.com/fp2002/fp2002dbinterface_files/frame.htm
--




| With DRW I created a form from the following statement
| update data set
| projdesc='::projdesc::',
| part='::part::',
| projentry='::projentry::',
| projact='::projact::',
| where projgen='::projgen::'
| Can I get the form only to update the database when information is typed
| into a particular field. Now if I wanted to update the part field I would
| have to fill in the rest of the fields before hitting submit or the database
| record would be blank for those other fields.
| Maybe there is a smarter way to do this
|
| Thanks, for the help
| -Greg
 
Back
Top