Need a Unique number based on two other fields

[harritwo]

I am attempting to build a database for asking questions of our customer.

What i am needing is how do i accomplish this task?

The field "Question Number" is sequential based on the Vessel and Contract Number.

For Example-

USS Neversail Contract-123 Question 1
FV Sad Day Contract 234 Question 1
USS Never Sail Contract ABD Question 1
USS Never Sail Contract 123 Question 2
USS Never Sail Contract 123 Question 3
FV Sad Day Contract 234 Question 2

Currently the Vessel and Contract number are selected by a Combo Box.

Attached is a Sample of the Database i have built so far. Any help is greatly appreciated. I know next to nothing about Macro's and VBL so i will need very specific examples, instructions on how to accomplish this task.

[Bulzie]

Could you count the number of records already in the table based on the vessel name they select, then add 1 to it for your next questions number? Something like:

me.QuestionNumber = me.VendorName & " " & me.ContractName & " Question " & DCount(me.VendorName, "MyTable", "VendorName = '" & Me.VendorName & "'") + 1