Hi,

I need to create a command button on a form that will only copy specific fields from the current record, and paste them as a new record. However, I cannot figure out how to specify fields, only the entire record. How can I do this?

Are you creating a new record on the form bound recordset or are you opening the recordset yourself?

Let's assume you want "Customer Name" and "Customer Address" copied to a new record when the button is pressed and you're working with the recordset bound to the form:

-----------------------------------------------------------------------------------------
Private Sub CreateNew_Button_Click()

  Dim sCustName As String, sCustAddr As String
  sCustName = [Customer Name]
  sCustAddr = [Customer Address]
  me.recordset.AddNew
  [Customer Name] = sCustName
  [Customer Address] = sCustAddr
  ****Other Code Manipulations****
end sub
-----------------------------------------------------------------------------------------

Ok that works the way I need. the only problem now is that there are times when some of those fields that need to be copied are blank; they aren't always filled in. So then I will get an "Invalid use of Null" error. How can I avoid this?

EDIT: I found that using the Nz() function seems to take care of it.
ex) strClient = Nz([Client])