Dmax to create unique ID

[Stika]

I have a form with a combobox where I select the Carrier witch then populates a multiselect listbox with all the record from that carrier in the specified date. When I select them and click save I want all the record ID(ConID) saved under the same ID(manifest ID) ie,



1 223
1 225
2 344
2 4444
Ect

It saves it in a table called Manifest With the fields Manifest ID and CONID which is a lookup field to a different table

here is my current code for the on click command

Dim db            As DAO.Database
    Dim rs            As DAO.Recordset
    Set db = CurrentDb()
    Set rs = db.OpenRecordset("Manifest", dbOpenDynaset)
    
    If List21.ItemsSelected.Count = 0 Then
        MsgBox "No Consignment notes selected"
        GoTo Endme
    End If
    
    If IsNull(Combo17.Value) Then
        MsgBox "No Carriers were selected"
        GoTo Endme
    End If
      
    
        For Each row In List21.ItemsSelected
            Conidval = List21.Column(0, row)
            rs.AddNew
            rs!ConID = Conidval
            rs.Update
        Next


Endme:
End Sub

Now ive done some searching and I thin dmax is what I want to use...but im not sure how to make it work

[June7]

Why do you think DMax is needed? You want to determine the maximum ManifestID in the table and increment it for use in this procedure?

ConIDval = DMax("ManifestID", "Manifest") + 1

[Stika]

Well im not sure whats needed...I want it to generate a ManifestID number...I thought DMax was the command to do it, But I dont think that works

[June7]

DMax will retrieve the maximum value of the ManifestID field. Then the calculation would increment it to the next number, assuming ManifestID is a numeric field. Then use that calculated value to populate field of the new Manifest record.

Why not use the Autonumber field to automatically generate ManifestID?

Want to provide db for analysis? Follow instructions at bottom of my post.

[Stika]

I Tried that code but what it is outputting in the table is

1 772
2 882
3 776

But Instead I want
1 772
1 882
1 776

So autonumber field isnt an option cause I want to be able to drag those details out later for a report by Manifest ID

I Found a Solution today I put that Dmax Code into a text box and It works exactally how I want it to.

Thanks for you help