A few Qs

D

Dragon

Hi I have a few questions if anyone could help me...

On a form, when you go to a cell with text in it, it selects all of the
text. I need to it to not select any text. I know I can use CellSelect(0) or
something like that, but is there an easier way or a way to loop it so I can
do so with all the fields at once?

Similar to above, I want to lock all of the fields and when user presses a
button it unlocks them for editing. It will unlock for just this record and
as soon as record changes (or lock button is pressed), all fields will be
locked again. I can do them individually, any way to loop it?

Is there a way to copy records? I would like to be able to provide a button
that when pressed copy all the fields of the record (on the form) and then
user can go to a blank record, paste all the fields and modify that ones
that have changed. Of course, I will not be copying the Key field.

Thank you.
 
Top