Pendragon Forms most definitely is a very good solution. The company i work for donated a copy of this software to our team, and it has proved very useful.
It interfaces with MS access, so when you hotsync the palm, the data automatically goes into the access table.
Their website is
www.pendragonsoftware.com