i thought i knew how to do this but it seems not... ive tried messing around with the default value to make this work but no cigar as yet.
i'd like the memo text area on my for to be pre-populated for the user when they open up a new form with data from another table. however the user is then free to make changes to that data and then click save which saves to the other table.
if the user decides to open the data they just saved then they should see the edited version of textarea data and not 'default' data
i hope of explained that ok.
as always, all help apprecited.