Search results

Yes.. They are running off the same table, tblReceipts. The only reason for the Receipt form and subform is to look tidy. The subform is datasheet view and wrapping it into a form looks neater.

Ok, a little confused.. I have a frmReceipts and subform frmReceiptsSub when now open with a checklistID from the previous form correctly and stay with the same ChecklistID for any additional entries in the frmReceiptsSub which is perfect. The only problem is that when if I close and re-open...

Ken, I just noticed that you can enter the data, but when you close and reopen the form, all but the first piece of data you entered disappear. Any ideas?

Ken, you are a genius! Thanks heaps.. It has been frustrating me for ages..

Not sure what you mean Ken. How would I do that?

Hi all, I have a form and a subform, with a button on the form to select the current subform (frmEvents) ChecklistID and open another form (frmReceipts) where the ChecklistID's match. (This field is common to both tables where ChecklistID is a one to many relationship between frmEvents and...

Re: Going insane- Subform going back to first record upon refresh Hi All, Going a little insane now. Using Lagbolts solution below, sometimes the solution works, sometimes it doesnt. After the implicit requery occurs through Lagbolts code below, the second combo box requery's correctly and...

G'day all, I've been trying to import a csv file using the transfertext code..eg: Private Sub Command0_Click() DoCmd.TransferText acImportDelim, , "tblRTO", "C:\Upload\RTO.csv", True End Sub and it brings forth an error message because from what I can work out is that it is trying to import...

Missed seeing that one... Hi Lagbolt, I've been using the database today and noticed something. The code you gave me works a treat when you are currently in the form and adding data to it. I've checked the tables and it stores the data in the tables immediately. When you exit and reopen the...

Lagbolt, You are an absolute LEGEND mate! Thank you very much... It worked. I've spent hours and hours trying different things to fix it and was unsuccessful. Thanks once again, really appreciate your help with this. Cheers, Mark

Hi All, I have a subform in datasheet view with two combo boxes. The first represents a Company Name, the second contains the contact person/s for a company. I have currently set up so that when entering a company name, the second combo box will requery and only display contact people from the...

Checking data and copying a record upon non existance! I've come across a temporary road block with this project! I've got a form with a subform (called frmChecklist) whereby if you double click on a line item in the subform, it opens up another form (called frmAuditing) where ChecklistID from...

Thanks guys. I tried the first suggestion just now and it works. :D Thank you for your input. Helps to have someone elses fresh eyes glaze over it.

Additional Information Sorry, I forgot to add that the checklist is currently a subform. Not sure if that makes a difference to the solution? Thanks, Mark

Hi all, I'm new to all of this and this is probably straight forward. I have a form in a MS Access database which is basically to be used like a checklist for a set of business processes in processing an application form that is received by the business. (The database is used to record the...