Recent content by Hammotime

Hi Mile-O, Just to let you know I think I may have solved the problem on the original form with a workaround. The close button I was using was created using a macro. I used your code from the Cancel button and seems to not be remembering the previous transaction. Not sure if I have...

Hi Mile-o. its very nice of u to create a mock up for me. really appreciate time u spent helping me. Having said that you will probably think I am pretty stupid for not being able to make mine work the same way. first I went through your form settings and changed everything in mine to match...

You are spot on about the List box. It is query of ID, Last name and First name from the Household table. The user will select the household from the list box, fill in the other fields then click the Process button activating the INSERT sql which will add a record to the PAYMENTS table. It is...

Hi Mile-O, Thanks for the prompt response. I think you are on the right track with the Where clause but just to clarify my table structure is as you suggested. I think I didn't explain myself well originally. The main table is the entity table and the transaction table I linked to the main...

Hi All, Struggling with this form. Need help please. First of all, just a general thanks for anyone that responds on these forums. It has really helped me out in the past. I have designed a form using the wizard from a table which records transactions for an entity. I have a Primary Key...