current record showing in the database.
Do you mean the current record showing on the form?

If so, you can control this with VBA in a number of ways. The easiest would be to pull the value of the form's objects by referring to them using the 'Me' keyword and the object's name. Example:
[VBA]Dim FirstName As String
FirstName = Me.txtFirstName[/VBA]
where txtFirstName is the name of the textbox object on the form that holds the first name value from your table.