Hi there

I would like to create a button for a form that would allow me to edit a
record, make changes, and save it as a new record.

I don't want to save a record and have it overwrite earlier information.

How will I create this button?

Thank you in advance

The best way would be to copy the existing record into a new record and then
edit the copy. I wonder why you need to do this. It indicates to me that you
***might*** have design problems in your table structure if you need to
duplicate most (or many) of the fields in one record in the next record.

Here is an old posting from Dirk Goldgar that I have in my archives. I've not
used it, but Dirk Goldgar is an MVP and I believe his coding skills are superior.

Duplicate record except for primary key, non-updatable fields, and specified
list of fields
From: "Dirk Goldgar" <(E-Mail Removed)>

'Needs to check to see if form's addnew property is true and if a current
record exists.
'Needs to make sure that the recordsetclone bookmark matches the form's
recordset bookmark

'----- start of code -----
Function CloneCurrentRecord(frm As Access.Form, ParamArray NotField())

Dim fld As DAO.Field
Dim strFieldName As String
Dim blnCopyField As Boolean
Dim intI As Integer

' Save the current record, if it's dirty
If frm.Dirty Then
On Error GoTo Err_SavingRecord
frm.Dirty = False
End If

' If we're at a new record, then there's nothing to copy.
If frm.NewRecord Then
MsgBox _
"Unable to copy blank record.", _
vbInformation, _
"Not Copied"
Exit Function
End If

On Error GoTo Err_General

' Create a new record in the form's recordsetclone, and
' copy all the updatable fields from the current record.
With frm.RecordsetClone

.AddNew

For Each fld In frm.Recordset.Fields

strFieldName = fld.Name

' Should this field be copied?
blnCopyField = True
If (fld.Attributes And dbAutoIncrField) <> 0 Then
blnCopyField = False
ElseIf (fld.Attributes And dbUpdatableField) = 0 Then
blnCopyField = False
ElseIf UBound(NotField) >= LBound(NotField) Then
For intI = LBound(NotField) To UBound(NotField)
If strFieldName = NotField(intI) Then
blnCopyField = False
Exit For
End If
Next intI
End If

If blnCopyField Then
.Fields(strFieldName).Value = fld.Value
End If

Next fld

.Update

.Bookmark = .LastModified
frm.Bookmark = .Bookmark

End With

Exit_Point:
Exit Function

Err_SavingRecord:
MsgBox _
"Error: Unable to save the current record " & _
"in order to copy it." & _
vbCr & vbCr & _
"Error number = " & Err.Number & _
", description = '" & Err.Description & "'", _
vbExclamation, _
"Can't Save Record"
Resume Exit_Point

Err_General:
MsgBox _
"Error: Unexpected error occurred while copying record." & _
vbCr & vbCr & _
"Error number = " & Err.Number & _
", description = '" & Err.Description & "'", _
vbExclamation, _
"Error Copying Record"
Resume Exit_Point

End Function
'----- end of code -----

The function is designed to copy all updatable fields from the current record
to a new record, and then move to that record. It uses the form's Recordset
and RecordsetClone, and assumes these are DAO recordsets, so it wouldn't work
in an ADP (though it could probably be modified to do so). Autonumber fields
and nonupdatable fields are excluded automatically, but it also provides for
an optional list of fields not to be copied.

You could call it using a line of code in a form's module, like this:

CloneCurrentRecord Me

or

CloneCurrentRecord Me, "ExcludeThisField", "ThisOneToo"

Or you could call it from a function expression in the OnClick event property
of a command button, like this:

=CloneCurrentRecord([Form])


As I said, I've only barely tested this, so there could be bugs or unknown
twists to it. In particular, I haven't tested the "nonupdatable" check for
fields.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

forest8 wrote:
> Hi there
>
> I would like to create a button for a form that would allow me to edit a
> record, make changes, and save it as a new record.
>
> I don't want to save a record and have it overwrite earlier information.
>
> How will I create this button?
>
> Thank you in advance
>

Hi

This is just what I needed.

The reason for this is that I have created a case management database file.

One of the form deals with reviewing previous week's entries and making
changes for the current week. I though it would be easier to review the older
record and make changes and save it as a new record.

Thanks again.

"John Spencer" wrote:

> The best way would be to copy the existing record into a new record and then
> edit the copy. I wonder why you need to do this. It indicates to me that you
> ***might*** have design problems in your table structure if you need to
> duplicate most (or many) of the fields in one record in the next record.
>
> Here is an old posting from Dirk Goldgar that I have in my archives. I've not
> used it, but Dirk Goldgar is an MVP and I believe his coding skills are superior.
>
> Duplicate record except for primary key, non-updatable fields, and specified
> list of fields
> From: "Dirk Goldgar" <(E-Mail Removed)>
>
> 'Needs to check to see if form's addnew property is true and if a current
> record exists.
> 'Needs to make sure that the recordsetclone bookmark matches the form's
> recordset bookmark
>
> '----- start of code -----
> Function CloneCurrentRecord(frm As Access.Form, ParamArray NotField())
>
> Dim fld As DAO.Field
> Dim strFieldName As String
> Dim blnCopyField As Boolean
> Dim intI As Integer
>
> ' Save the current record, if it's dirty
> If frm.Dirty Then
> On Error GoTo Err_SavingRecord
> frm.Dirty = False
> End If
>
> ' If we're at a new record, then there's nothing to copy.
> If frm.NewRecord Then
> MsgBox _
> "Unable to copy blank record.", _
> vbInformation, _
> "Not Copied"
> Exit Function
> End If
>
> On Error GoTo Err_General
>
> ' Create a new record in the form's recordsetclone, and
> ' copy all the updatable fields from the current record.
> With frm.RecordsetClone
>
> .AddNew
>
> For Each fld In frm.Recordset.Fields
>
> strFieldName = fld.Name
>
> ' Should this field be copied?
> blnCopyField = True
> If (fld.Attributes And dbAutoIncrField) <> 0 Then
> blnCopyField = False
> ElseIf (fld.Attributes And dbUpdatableField) = 0 Then
> blnCopyField = False
> ElseIf UBound(NotField) >= LBound(NotField) Then
> For intI = LBound(NotField) To UBound(NotField)
> If strFieldName = NotField(intI) Then
> blnCopyField = False
> Exit For
> End If
> Next intI
> End If
>
> If blnCopyField Then
> .Fields(strFieldName).Value = fld.Value
> End If
>
> Next fld
>
> .Update
>
> .Bookmark = .LastModified
> frm.Bookmark = .Bookmark
>
> End With
>
> Exit_Point:
> Exit Function
>
> Err_SavingRecord:
> MsgBox _
> "Error: Unable to save the current record " & _
> "in order to copy it." & _
> vbCr & vbCr & _
> "Error number = " & Err.Number & _
> ", description = '" & Err.Description & "'", _
> vbExclamation, _
> "Can't Save Record"
> Resume Exit_Point
>
> Err_General:
> MsgBox _
> "Error: Unexpected error occurred while copying record." & _
> vbCr & vbCr & _
> "Error number = " & Err.Number & _
> ", description = '" & Err.Description & "'", _
> vbExclamation, _
> "Error Copying Record"
> Resume Exit_Point
>
> End Function
> '----- end of code -----
>
> The function is designed to copy all updatable fields from the current record
> to a new record, and then move to that record. It uses the form's Recordset
> and RecordsetClone, and assumes these are DAO recordsets, so it wouldn't work
> in an ADP (though it could probably be modified to do so). Autonumber fields
> and nonupdatable fields are excluded automatically, but it also provides for
> an optional list of fields not to be copied.
>
> You could call it using a line of code in a form's module, like this:
>
> CloneCurrentRecord Me
>
> or
>
> CloneCurrentRecord Me, "ExcludeThisField", "ThisOneToo"
>
> Or you could call it from a function expression in the OnClick event property
> of a command button, like this:
>
> =CloneCurrentRecord([Form])
>
>
> As I said, I've only barely tested this, so there could be bugs or unknown
> twists to it. In particular, I haven't tested the "nonupdatable" check for
> fields.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> forest8 wrote:
> > Hi there
> >
> > I would like to create a button for a form that would allow me to edit a
> > record, make changes, and save it as a new record.
> >
> > I don't want to save a record and have it overwrite earlier information.
> >
> > How will I create this button?
> >
> > Thank you in advance
> >
> .
>

I posted this reply 20 hours ago, but it is not showing on the news group.


It sounds as if you want to create a new record and show some of the same
values as the previous record already there in the new record when it is
created?

You can do this using the code below for each control where you want to use
the value from the previous record.

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

If 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.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"forest8" <(E-Mail Removed)> wrote in message
news:4E67A117-966B-42E8-9390-(E-Mail Removed)...
> Hi there
>
> I would like to create a button for a form that would allow me to edit a
> record, make changes, and save it as a new record.
>
> I don't want to save a record and have it overwrite earlier information.
>
> How will I create this button?
>
> Thank you in advance
>

I came across this and seem to have the exact same needs - however i cannot seem to get the code to work?

Bascially i need to pull up a record based on a field, which i have done through a combo box - its sort of a secondary "primary key". Its a combination of a few fields which makes the record unique for our lookup purposes.

Once the record is pulled up, i need to click a button that will save the changes made as a new record without overwriting the prior record (or hte historical data) as this is important for us to maintain.

Thanks

> On Saturday, March 06, 2010 4:18 PM forest8 wrote:

> Hi there
>
> I would like to create a button for a form that would allow me to edit a
> record, make changes, and save it as a new record.
>
> I do not want to save a record and have it overwrite earlier information.
>
> How will I create this button?
>
> Thank you in advance


>> On Sunday, March 07, 2010 7:51 AM John Spencer wrote:

>> The best way would be to copy the existing record into a new record and then
>> edit the copy. I wonder why you need to do this. It indicates to me that you
>> ***might*** have design problems in your table structure if you need to
>> duplicate most (or many) of the fields in one record in the next record.
>>
>> Here is an old posting from Dirk Goldgar that I have in my archives. I have not
>> used it, but Dirk Goldgar is an MVP and I believe his coding skills are superior.
>>
>> Duplicate record except for primary key, non-updatable fields, and specified
>> list of fields
>>
>> 'Needs to check to see if form's addnew property is true and if a current
>> record exists.
>> 'Needs to make sure that the recordsetclone bookmark matches the form's
>> recordset bookmark
>>
>> '----- start of code -----
>> Function CloneCurrentRecord(frm As Access.Form, ParamArray NotField())
>>
>> Dim fld As DAO.Field
>> Dim strFieldName As String
>> Dim blnCopyField As Boolean
>> Dim intI As Integer
>>
>> ' Save the current record, if it is dirty
>> If frm.Dirty Then
>> On Error GoTo Err_SavingRecord
>> frm.Dirty = False
>> End If
>>
>> ' If we are at a new record, then there is nothing to copy.
>> If frm.NewRecord Then
>> MsgBox _
>> "Unable to copy blank record.", _
>> vbInformation, _
>> "Not Copied"
>> Exit Function
>> End If
>>
>> On Error GoTo Err_General
>>
>> ' Create a new record in the form's recordsetclone, and
>> ' copy all the updatable fields from the current record.
>> With frm.RecordsetClone
>>
>> .AddNew
>>
>> For Each fld In frm.Recordset.Fields
>>
>> strFieldName = fld.Name
>>
>> ' Should this field be copied?
>> blnCopyField = True
>> If (fld.Attributes And dbAutoIncrField) <> 0 Then
>> blnCopyField = False
>> ElseIf (fld.Attributes And dbUpdatableField) = 0 Then
>> blnCopyField = False
>> ElseIf UBound(NotField) >= LBound(NotField) Then
>> For intI = LBound(NotField) To UBound(NotField)
>> If strFieldName = NotField(intI) Then
>> blnCopyField = False
>> Exit For
>> End If
>> Next intI
>> End If
>>
>> If blnCopyField Then
>> .Fields(strFieldName).Value = fld.Value
>> End If
>>
>> Next fld
>>
>> .Update
>>
>> .Bookmark = .LastModified
>> frm.Bookmark = .Bookmark
>>
>> End With
>>
>> Exit_Point:
>> Exit Function
>>
>> Err_SavingRecord:
>> MsgBox _
>> "Error: Unable to save the current record " & _
>> "in order to copy it." & _
>> vbCr & vbCr & _
>> "Error number = " & Err.Number & _
>> ", description = '" & Err.Description & "'", _
>> vbExclamation, _
>> "Can't Save Record"
>> Resume Exit_Point
>>
>> Err_General:
>> MsgBox _
>> "Error: Unexpected error occurred while copying record." & _
>> vbCr & vbCr & _
>> "Error number = " & Err.Number & _
>> ", description = '" & Err.Description & "'", _


>>> On Sunday, March 07, 2010 10:26 AM forest8 wrote:

>>> Hi
>>>
>>> This is just what I needed.
>>>
>>> The reason for this is that I have created a case management database file.
>>>
>>> One of the form deals with reviewing previous week's entries and making
>>> changes for the current week. I though it would be easier to review the older
>>> record and make changes and save it as a new record.
>>>
>>> Thanks again.
>>>
>>> "John Spencer" wrote:


>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>> Lucene.Net Indexing Searching Entry Level Tutorial
>>> http://www.eggheadcafe.com/tutorials...-tutorial.aspx

I came across this and seem to have the exact same needs - however i cannot seem to get the code to work?

Bascially i need to pull up a record based on a field, which i have done through a combo box - its sort of a secondary "primary key". Its a combination of a few fields which makes the record unique for our lookup purposes.

Once the record is pulled up, i need to click a button that will save the changes made as a new record without overwriting the prior record (or hte historical data) as this is important for us to maintain.

Thanks

> On Saturday, March 06, 2010 4:18 PM forest8 wrote:

> Hi there
>
> I would like to create a button for a form that would allow me to edit a
> record, make changes, and save it as a new record.
>
> I do not want to save a record and have it overwrite earlier information.
>
> How will I create this button?
>
> Thank you in advance


>> On Sunday, March 07, 2010 7:51 AM John Spencer wrote:

>> The best way would be to copy the existing record into a new record and then
>> edit the copy. I wonder why you need to do this. It indicates to me that you
>> ***might*** have design problems in your table structure if you need to
>> duplicate most (or many) of the fields in one record in the next record.
>>
>> Here is an old posting from Dirk Goldgar that I have in my archives. I have not
>> used it, but Dirk Goldgar is an MVP and I believe his coding skills are superior.
>>
>> Duplicate record except for primary key, non-updatable fields, and specified
>> list of fields
>>
>> 'Needs to check to see if form's addnew property is true and if a current
>> record exists.
>> 'Needs to make sure that the recordsetclone bookmark matches the form's
>> recordset bookmark
>>
>> '----- start of code -----
>> Function CloneCurrentRecord(frm As Access.Form, ParamArray NotField())
>>
>> Dim fld As DAO.Field
>> Dim strFieldName As String
>> Dim blnCopyField As Boolean
>> Dim intI As Integer
>>
>> ' Save the current record, if it is dirty
>> If frm.Dirty Then
>> On Error GoTo Err_SavingRecord
>> frm.Dirty = False
>> End If
>>
>> ' If we are at a new record, then there is nothing to copy.
>> If frm.NewRecord Then
>> MsgBox _
>> "Unable to copy blank record.", _
>> vbInformation, _
>> "Not Copied"
>> Exit Function
>> End If
>>
>> On Error GoTo Err_General
>>
>> ' Create a new record in the form's recordsetclone, and
>> ' copy all the updatable fields from the current record.
>> With frm.RecordsetClone
>>
>> .AddNew
>>
>> For Each fld In frm.Recordset.Fields
>>
>> strFieldName = fld.Name
>>
>> ' Should this field be copied?
>> blnCopyField = True
>> If (fld.Attributes And dbAutoIncrField) <> 0 Then
>> blnCopyField = False
>> ElseIf (fld.Attributes And dbUpdatableField) = 0 Then
>> blnCopyField = False
>> ElseIf UBound(NotField) >= LBound(NotField) Then
>> For intI = LBound(NotField) To UBound(NotField)
>> If strFieldName = NotField(intI) Then
>> blnCopyField = False
>> Exit For
>> End If
>> Next intI
>> End If
>>
>> If blnCopyField Then
>> .Fields(strFieldName).Value = fld.Value
>> End If
>>
>> Next fld
>>
>> .Update
>>
>> .Bookmark = .LastModified
>> frm.Bookmark = .Bookmark
>>
>> End With
>>
>> Exit_Point:
>> Exit Function
>>
>> Err_SavingRecord:
>> MsgBox _
>> "Error: Unable to save the current record " & _
>> "in order to copy it." & _
>> vbCr & vbCr & _
>> "Error number = " & Err.Number & _
>> ", description = '" & Err.Description & "'", _
>> vbExclamation, _
>> "Can't Save Record"
>> Resume Exit_Point
>>
>> Err_General:
>> MsgBox _
>> "Error: Unexpected error occurred while copying record." & _
>> vbCr & vbCr & _
>> "Error number = " & Err.Number & _
>> ", description = '" & Err.Description & "'", _


>>> On Sunday, March 07, 2010 10:26 AM forest8 wrote:

>>> Hi
>>>
>>> This is just what I needed.
>>>
>>> The reason for this is that I have created a case management database file.
>>>
>>> One of the form deals with reviewing previous week's entries and making
>>> changes for the current week. I though it would be easier to review the older
>>> record and make changes and save it as a new record.
>>>
>>> Thanks again.
>>>
>>> "John Spencer" wrote:


>>>> On Monday, September 20, 2010 2:57 PM Matt Litwin wrote:

>>>> I came across this and seem to have the exact same needs - however i cannot seem to get the code to work?
>>>>
>>>>
>>>>
>>>> Bascially i need to pull up a record based on a field, which i have done through a combo box - its sort of a secondary "primary key". Its a combination of a few fields which makes the record unique for our lookup purposes.
>>>>
>>>>
>>>>
>>>> Once the record is pulled up, i need to click a button that will save the changes made as a new record without overwriting the prior record (or hte historical data) as this is important for us to maintain.
>>>>
>>>>
>>>>
>>>> Thanks


>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>> Lucene.Net Indexing Searching Entry Level Tutorial
>>>> http://www.eggheadcafe.com/tutorials...-tutorial.aspx

It's difficult to assist you with code that you did not post and that we
cannot see.

It would be helpful, too, if you'd describe the Primary Key you are using
and how the Primary Key of the newly-saved record would be determined.

Of course, if you used an Autonumber as Primary Key, that would allow you to
save the record, but in that case, you'll need some sort of "natural key" to
use to retrieve it, later.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Matt Litwin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I came across this and seem to have the exact same needs - however i cannot
>seem to get the code to work?
>
> Bascially i need to pull up a record based on a field, which i have done
> through a combo box - its sort of a secondary "primary key". Its a
> combination of a few fields which makes the record unique for our lookup
> purposes.
>
> Once the record is pulled up, i need to click a button that will save the
> changes made as a new record without overwriting the prior record (or hte
> historical data) as this is important for us to maintain.
>
> Thanks
>
>> On Saturday, March 06, 2010 4:18 PM forest8 wrote:
>
>> Hi there
>>
>> I would like to create a button for a form that would allow me to edit a
>> record, make changes, and save it as a new record.
>>
>> I do not want to save a record and have it overwrite earlier information.
>>
>> How will I create this button?
>>
>> Thank you in advance
>
>
>>> On Sunday, March 07, 2010 7:51 AM John Spencer wrote:
>
>>> The best way would be to copy the existing record into a new record and
>>> then
>>> edit the copy. I wonder why you need to do this. It indicates to me
>>> that you
>>> ***might*** have design problems in your table structure if you need to
>>> duplicate most (or many) of the fields in one record in the next record.
>>>
>>> Here is an old posting from Dirk Goldgar that I have in my archives. I
>>> have not
>>> used it, but Dirk Goldgar is an MVP and I believe his coding skills are
>>> superior.
>>>
>>> Duplicate record except for primary key, non-updatable fields, and
>>> specified
>>> list of fields
>>>
>>> 'Needs to check to see if form's addnew property is true and if a
>>> current
>>> record exists.
>>> 'Needs to make sure that the recordsetclone bookmark matches the form's
>>> recordset bookmark
>>>
>>> '----- start of code -----
>>> Function CloneCurrentRecord(frm As Access.Form, ParamArray NotField())
>>>
>>> Dim fld As DAO.Field
>>> Dim strFieldName As String
>>> Dim blnCopyField As Boolean
>>> Dim intI As Integer
>>>
>>> ' Save the current record, if it is dirty
>>> If frm.Dirty Then
>>> On Error GoTo Err_SavingRecord
>>> frm.Dirty = False
>>> End If
>>>
>>> ' If we are at a new record, then there is nothing to copy.
>>> If frm.NewRecord Then
>>> MsgBox _
>>> "Unable to copy blank record.", _
>>> vbInformation, _
>>> "Not Copied"
>>> Exit Function
>>> End If
>>>
>>> On Error GoTo Err_General
>>>
>>> ' Create a new record in the form's recordsetclone, and
>>> ' copy all the updatable fields from the current record.
>>> With frm.RecordsetClone
>>>
>>> .AddNew
>>>
>>> For Each fld In frm.Recordset.Fields
>>>
>>> strFieldName = fld.Name
>>>
>>> ' Should this field be copied?
>>> blnCopyField = True
>>> If (fld.Attributes And dbAutoIncrField) <> 0 Then
>>> blnCopyField = False
>>> ElseIf (fld.Attributes And dbUpdatableField) = 0 Then
>>> blnCopyField = False
>>> ElseIf UBound(NotField) >= LBound(NotField) Then
>>> For intI = LBound(NotField) To UBound(NotField)
>>> If strFieldName = NotField(intI) Then
>>> blnCopyField = False
>>> Exit For
>>> End If
>>> Next intI
>>> End If
>>>
>>> If blnCopyField Then
>>> .Fields(strFieldName).Value = fld.Value
>>> End If
>>>
>>> Next fld
>>>
>>> .Update
>>>
>>> .Bookmark = .LastModified
>>> frm.Bookmark = .Bookmark
>>>
>>> End With
>>>
>>> Exit_Point:
>>> Exit Function
>>>
>>> Err_SavingRecord:
>>> MsgBox _
>>> "Error: Unable to save the current record " & _
>>> "in order to copy it." & _
>>> vbCr & vbCr & _
>>> "Error number = " & Err.Number & _
>>> ", description = '" & Err.Description & "'", _
>>> vbExclamation, _
>>> "Can't Save Record"
>>> Resume Exit_Point
>>>
>>> Err_General:
>>> MsgBox _
>>> "Error: Unexpected error occurred while copying record." & _
>>> vbCr & vbCr & _
>>> "Error number = " & Err.Number & _
>>> ", description = '" & Err.Description & "'", _
>
>
>>>> On Sunday, March 07, 2010 10:26 AM forest8 wrote:
>
>>>> Hi
>>>>
>>>> This is just what I needed.
>>>>
>>>> The reason for this is that I have created a case management database
>>>> file.
>>>>
>>>> One of the form deals with reviewing previous week's entries and making
>>>> changes for the current week. I though it would be easier to review the
>>>> older
>>>> record and make changes and save it as a new record.
>>>>
>>>> Thanks again.
>>>>
>>>> "John Spencer" wrote:
>
>
>>>>> On Monday, September 20, 2010 2:57 PM Matt Litwin wrote:
>
>>>>> I came across this and seem to have the exact same needs - however i
>>>>> cannot seem to get the code to work?
>>>>>
>>>>>
>>>>>
>>>>> Bascially i need to pull up a record based on a field, which i have
>>>>> done through a combo box - its sort of a secondary "primary key". Its
>>>>> a combination of a few fields which makes the record unique for our
>>>>> lookup purposes.
>>>>>
>>>>>
>>>>>
>>>>> Once the record is pulled up, i need to click a button that will save
>>>>> the changes made as a new record without overwriting the prior record
>>>>> (or hte historical data) as this is important for us to maintain.
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>
>
>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>> Lucene.Net Indexing Searching Entry Level Tutorial
>>>>> http://www.eggheadcafe.com/tutorials...-tutorial.aspx