Actually don't treat DateID as optional. You'll find its the easiest way to a hold of lstDates.ItemData(lstDates.ListIndex). I'm using it as the bound column of the listbox.

Bob

Final thought. If you want to be able to add new divers through this form as well as new date data, you'll need to make sure that the diver record (DiverID, FirstName, LastName) is saved before attempting to enter date information for that diver. An easy way to do that would be to add a 'Save' button to your form, and place this behind it:

Private Sub cmdSave_Click()
    DoCmd.RunCommand acCmdSaveRecord
End Sub

The diver record has to exist in tblNewDivers before you can use the cmdAddDate button to start adding dates to tblDates.

Bob

One thing that I have done in some applications is to hide the tblDates subform whenever I add a new record to tblNewDiver via frmDivers. Clicking on the Save button can also un-hide the subform.

This eliminates the possibility of accidental orphan records in the tblDates table.

Rand

HI Bob and rgerald,

right first things first thanx for all your help, but im having a problem with the new set of code, ive actually changed my db to work around the new tbl names and fields but am having no luck first i get a debug problem then redone it again and now get a parameter prob.

Just a quick note, in tblnewdiver diver i do have more than 3 fields(in orginal version) you have just methioned DiverID, Firstname and Lastname, or do the other fields just not applicable when writing to the table...?(another 12 fields)

Ok what ive done is uploaded the db(256k Zipped) to my website, this version of the db has been developed around the code you have given me(well most of it).
could you possible have a look at it and tell me where ive gone wrong or email me the correct version of how its suppose to work(email address on website)
www.whathappenedwhen.co.uk/access/version1.htm
ive uploaded a copy of the orginal db(with the first set of code you gave me as well)

thanx guys!


P.s is their anyway of changing what the msgbox says when deleting a record, it says "Do you want to delete record 0" could it say "Do you want to delete record 12/12/03" or what ever date they select to delete?