Form submit question

[Guest]

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

 

[Stefan B Rusynko]

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=':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