Default value previous record & calculated control from different query

[krefael]

Hello,
Thanks for the help in this forum.
I have 2 problems to solve, please help me.

1. I try to set the default value of a control in a form to get the data from the last record enterd in the table. Looking fo simple way.

2. I have query that calculte the sum according to what I choose in the form ("query1" - have only one line). I want a control to show me the value of this query.

(Using Access 2010)


Thanks,
krefael

[June7]

1. Review
http://allenbrowne.com/ser-24.html
http://support.microsoft.com/kb/210236
http://support.microsoft.com/kb/210504

2. Options
a. DLookup expression in textbox
b. Listbox RowSource set to the query

[Missinglinq]

In #1, if you're speaking of

• Opening Access
• Entering a series of Records
• Have a Field Default to the Value entered in the previous Record

the simple way would be to use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record.

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

Note that this code/syntax can be used for any Datatype.

Linq ;0)>