Pls help a newbie with Form/Subform

[lcook1974]

How about creating a "delete" query? So basically you create a query that has all the fields in it you want associated with the Phonelog ID and UserID. The create a button that will take either the "phoneLogID" or "UserID" and run that query. I think this will bypass the referential integrity issue you are running into.

 

[lcook1974]

Try this out...

ignore the delete query in here...you can just delete that if you like.

I put a "delete" button on the edit form

 

[lcook1974]

Put this under the "Close" button VB code on the UpdateUser form.

Forms!frmUserMaster.List30.Requery