Bob Heygood
bheygood at abestsystems.com
Wed Jan 3 22:47:51 CST 2007
Hello to the list,
When I select a record on a form and copy it and paste append, I seem to
only get a new record with data in those fields which have a visible control
on the form.
I have tested this and am wondering if someone could do the same.
My need is to only display some fields with controls on the form but when
coping the record, have all the fields data be pasted into the new record.
This seems to be the case whether I do it from the menu items manually or
use code using the
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Or
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
Methods.
I am totally out of space on this form and would like this to work.
Otherwise I guess I will have to use SQL in the code.
A2003
TIA
Bob Heygood