Not in list error, will not LinkCriteria????

[d9pierce1]

No problem, Thanks

[accesstos]

Dave,

Please, check my suggestion in attachment. I think that now it works as you expected. Start to play with the ProjectFrm.

I have made some changes in database structure for the “Member Contacts” (see schema, queries and forms).

Just for the record: Within the NotInList event, the CboContactID doesn’t have the new ContactID yet. You have to retrieve it form the ContactTbl directly using a DMAX().

"[ContactID]=" & DMax("ContactID", "ContactTbl")

Cheers,
John

[d9pierce1]

Hi accesstos,
That is exactly what i was looking for. I cannot thank you enough..
Have a great day and I will consider this solved.
Again, Thank you
Dave

[Micron]

I backed off when the sample db was posted so that you could have time to verify. So glad to see you have a solution.

[accesstos]

Dave, you are very welcome!
I am glad I was able to help.

Thank you for make my nickname known to all.
John