Default From Previous Record

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Can anyone tell me how to initialize a field in a detail
subform with its value from the previous record?

Thanks for the help.
 
Hi Kevin,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you started in the right
direction:

Fill Record with Data from Previous Record Automatically

http://support.microsoft.com/default.aspx?scid=kb;en-us;210236

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Kevin:

There are many ways to do it.
1. Keep the last record in Private variables/array, and
add a procedure to the On Current Form's Event and set
the values to the "NEW" record

2.Store the values in a Private Type structure and the do
the same as above.

3.Use ADO to open add a new record to the table if the
current record is new

4.Bookmark the last record, store it in a variant
varialble set the values to NEW record

There are many other ways (for example:using queries) but
i think this are easier to apply

Note that you have to check if the current record is a
new record, otherwise you will overwrite the contents.

Good luck

Estuardo
 
Thanks, Dennis. Both the copy a whole record procedure
and the shortcut key Ctrl-' were useful.
 
Back
Top