Recent content by safinch

Hi Bob did you find anything on the database I sent in June? I thinkl I'd tried everything you suggested cheers Simon

Hi Thanks for that - here it is Regards Simon

Hi I've tried that but I still get the same error - and I can't attach the database as it's more than 2 mb. Can I send it to an email address? Thanks for your help Simon

Thanks Bob I had a look at the tutorial and I've tried using this : =[frmBorrowSub].[Form]![text20] where frmborrowsub is the name of the subform control name and text20 is a text box on the footer of the sub form but I still get the #error message in the text box on the main form - do I...

Thanks for your interest The forms are called frmBorrowMain and frmBorrowsub. On the subform I have a text box in the detail section calculating fines called txtfine, with a control source of: =(Now()-[returndate])*0.2 then in the footer of the subform I have another text box called...

Thanks I'm sure the names aren't an issue as Ive tried changing them several; times and I use the txt prefix whenever I create a test box - I've just tried it on another database and I'm getting the same problem. A colleague thinks it may be an issue with my network profile.

I'm trying to use a text box from the footer of my sub form to show in a text box in my main form. I have done this often in the past and have several working examples. Today I added three such boxes to my main form, th first two worked and when I added the third the message #error appeared in...

Hi I'm trying to make a report throw to a new page when a group header changes. I've just gone over to 2007. I'm changing the property of the group header to force new page after section and nothing happens - any thoughts cheers SF