Unanswered: INSERT query problem, small code....PLEASE HELP!!
Hi there, well, I have a problem with my INSERT query, I have tblDueDates, tblClient and three main forms.……..but I get errors when trying to insert payments. I have tblClient and tblDueDates and 1.frmDueDates, to insert and display the due dates for the payments , 2.frmPayDateList in order to display the Due Dates of all clients in a list according to their due dates and 3.frmClientsPayedrecord, to see the payments of each client after the user clicked on the ‘payed’ button on the 2.frmPayDateList form. Form frmDueDates and frmClientsPayrecord are linked to tblDueDates.
But I get an error when clicking on that ‘payed’ button on the frmPayDateList. I use an INSERT query to insert the payments into that one table tblDueDates and also it should avoid duplication with this query and it’s where clause!!!!
I have attached a small sample zip file to view the query code on that ‘payed’ button on the 2.frmPayDateList form. Can you help me out to see what is wrong here?? Thanks…..
Hi there Sbaxter, thanks for the info…I actually moved the due dates and pay dates into one table, it’s less work and its fine. One thing though, I have added an undo button to represent an undo situation after a user has clicked on the ‘pay’ button and decided to undo the info after clicking the ‘pay’ button. I used a Delete query, so it can delete the fields that were updated from the ‘pay’ button. I used the following code and it seems to work fine but it deletes an entire row instead of just the fields specified in the query with it’s criteria where clause for that one table.