Cy,
it sounds as if you are trying to set defaults for some of the fields in the
form.
You can do this in a couple of ways.

1.-------------------------------------------------------
Private Sub controlname_AfterUpdate()
'text field
Me.TheTextControl.DefaultValue =  """" & Me. TheTextControl  & """"

'date field
Me.TheDateControl.DefaultValue = "#" & Me.TheDateControl & "#"

'number field
Me.TheNumberField.DefaultValue = Me.TheNumberField
End Sub

When the user enters XYZ it will set the DefaultValue property to "XYZ"
which will be used for the next entry. When you open the form you must enter
values in the controls to be able to see the default values when you move to
the next record.

2.-------------------------------------------------------
If you want a subform to inherit a value from the mainform (and don't want
it
editable) you can make that field part of the Master/Child Field pair.

3.-------------------------------------------------------
If you want the value available when the form first opens to enter data, you
can use the field's OnGotFocus event.
Copy, paste, and edit the following code:

Private Sub controlname_GotFocus()
'Fetching default value from previous record
Dim rs As DAO.Object
Set rs = Me.RecordsetClone

' Don't do anything if no previous record exist or not new Record
If rs.EOF Or Not Me.NewRecord Then
Else
With rs
.MoveLast
Me![YourFieldNameHere] = .Fields("YourFieldNameHere")
End With
End If

When you tab over to the field, it will default to the previous record's
value.

Jeanette Cunningham -- Melbourne Victoria Australia