Default From Previous Record

[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.

 

[Dennis Schmidt]

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

 

[Guest]

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

 

[Kevin]

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

 

[Kevin]

Thanks for the help, Estuardo.