Form submit question

With DRW I created a form from the following statement
update data set
projdesc=':rojdesc::',
part=':art::',
projentry=':rojentry::',
projact=':rojact::',
where projgen=':rojgen::'
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/defaul...kb;en-us;825502 and
http://www.frontpagehowto.com/fp200...files/frame.htm
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Hayden Greg" <HaydenGreg@discussions.microsoft.com> wrote in message news:515FF828-7212-408B-A37E-81E23CB1E134@microsoft.com...
| With DRW I created a form from the following statement
| update data set
| projdesc=':rojdesc::',
| part=':art::',
| projentry=':rojentry::',
| projact=':rojact::',
| where projgen=':rojgen::'
| 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