Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copying old record into new record

Status
Not open for further replies.

JodyAmy

Programmer
Feb 12, 2001
21
US
I have a procedure to copy records on a form in datasheet view to create new records because of excessive data entry. Only problem is that after I made a few programming changes, three fields are not copied to the new record. These fields are part of drop-down menus that pull from other tables or are unbound fields. The remainder of the fields are bound to the same table as the form and are copied over.

Any quick fix to get these fields to copy over?

Jody
 
Hmmmmmmmmmm,

Quite obviously, you need to save the contents of the errant fields (probably in the BeforeUpdate event) and then restore them (probably in the OnCurrent event). Without a look at the code currently in place to save the bound fields, it is somewhat difficult to assess wheather the additional gather-scatter operations should be included in that process or additional processing needs to be done.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top