How to make default value in a form be the last record entered?

[BrianHamel]

I'm a very novice Access user and want to know how to make the default value in a form field equal the same value as the last record that was entered.

I found something called first, last function and attempted to use it as follows: =last([table name]![field name]) but it didn't work.

Any suggestions?

Thanks

Brian Hamel
bhamel@phenoxy.com

 

[TheAceMan1]

How are ya BrianHamel . . . . .

Hmmmmmmmmmmmmm . . . . . just what is your definition of [blue]Default Value[/blue]?

See Ya! . . . . . .

 

[TheAceMan1]

Hay BrianHamel . . . .

I hope I didn't sound condecending. If I did. . . . I aplolgize . . . .

Here's an example of doing what ya want(in your forms Current Event procedure):

[blue]Private Sub Form_Current
   If Me.NewRecord Then
      Dim rst as DAO.Recordset
      Set rst=Me.RecordsetClone
      rst.MoveLast

      Me!Field1=rst!Field1
      Me!Field2=rst!Field2
               .
               .
      Me!FieldN=rst!FieldN

      set rst=Nothing
   End If
End Sub[/blue]

Here your updating fields in a new record. Not setting default. Since its dynamic, whats the difference!

See Ya! . . . . . .