I have experience in working with Access queries, forms and reports.
have been programming in access for the past 2 years.
Hi, you got to create a join between these two tables on ClientID and then perform the delete query. For eg DELETE FROM tbltrcclient WHERE ClientID IN ( SELECT T.ClientID FROM tbltrcclient T
Hi Enrico, there has to be some common column or matching criteria. What's the structure of the two tables?
Hi Laura, I don't think you need to create any macro. Seems there is some conflict/error in the control name. Just delete that checkbox control and add a new one (this time give it a name without any
Hi Laura, yes that is possible. Drag and drop a checkbox onto the form. Next add the following code to the checkbox's AfterUpdate event - Private Sub Check4_AfterUpdate() If Me!Check4.Value = True
Hi Ron, you will pass that data to your query. You will have to check the exact syntax for that. For ex - SELECT * FROM TableName WHERE LocationID = intLocationID AND UserID = intUserID where
Answers by Expert: