2 Subform Problems: 1) Can't Update 2) Connect saved data to one date

[Heatshiver]

I have a form that has three basic criteria used on all forms from one table: 1) Date 2) UserID 3) ProjectID. I then have a subform that uses data from another table.

My first major concern is that I cannot get the subform to be updated. From what I have read it seems like my settings are correct to allow this, but I am obviously missing something.

My second major concern is that I need the information from the subform to have a connection the first table with three basic criteria from above. That way I can ensure that if something has already been done for that date, with that user, on that project, I can warn the user that it has already been done.

I've been stumped for quite some time on how to go about this, but I assume that is has to do with Master/Child fields as this concept is still not quite clear to me. At first I had just the Day listed as the Master and the Child. Then I changed it so that I had Date, UserID, and ProjectID as the Master, and Comments as the Child (as the subform is for comments). In either case, I am not sure if they are connecting properly...

 

[vbaInet]

The Link Master/Child Fields properties refer to the field names in the parent form and the child form that relate to them. Click the button next to them and it will come up with a dialogue box asking you to choose the parent field and the child field. Access will use those fields to synch and filter the subform to the parent form via those fields.

To check if an item already exists, perform a count using the DCount() function. If it's above 0 that means it exists in the underlying table. More on DCount() here:

http://www.techonthenet.com/access/functions/domain/dcount.php