Search results

Nope They are both Text. Any help to you ? Charlie

Ok heres a screenshot of the relationships I have tried. Charlie

I am trying to create one to many relationships in this database file I am currently experimenting with and cannot get the thing to link the way i want. Could someone give me some advice on it please. I was trying to maintain referential Integerity, but have found it impossible. Thanks Charlie

ahh got it I used, =[frmTestHistorySubform].[Form]![txtAmount] is that what you were saying. Charlie

I dont get it Ive used the exact method I used on Jade on another main form subform and it works. I just cannot understand why this one should be any different, I am looking at the working version now and im puzzled. Charlie

Im having a nightmare getting the figures on this form to total, I cant understand what is wrong, i have done this before. the total amount I am getting after my calc is £3.95 which is only half of what I would expect. I am using =sum ([amount]) in the footer of the subform, and in the mainform...

Aha Found it, I had the toolbox undocked, the subreport button wasnt on it. Thanks Again Charlie

Erm I might be dum but I dont see any button marked subform/subreports, you mean the wizard button on the toolbox right? control wizard? Charlie

Many thanks I would never have figured that one out. Charlie

I am using access 2002, I have two forms, one named frmEquipmentWithTests which I want to be my main form, I also have a form named frmTestHistorySubform which I want to be my subform, my question is: How do I insert the subform into the mainform ? Ive read my book and cant find anything about...

Im trying to calculate the totals in a text box on my subform using this syntax, =sum([Amount]) the trouble is the text box remains blank, could someone take a look please. http://homepage.ntlworld.com/charlie_chuck/invoice12.mdb The subform is part of frmInvoiceSubformsupplier. Thanks Charlie

At last I did it, thanks for your patience, i bet you hate me. Charlie

Thanks Yours works fine but mine still wont, I will just have to try and try again until it does, the name of the game is learning this. Thanks Again Charlie

Thats what I want Exactly so, but when I try the procedure you describe, which is: select properties of combo box supplier code, select event tab, after update [event procedure] paste Me.SName = Me.[Supplier code].Column(1) after [event procedure] Go to text box properties, name it SName...

Well Sorta half working, the SName is available for selection for the text box, but the #error still occurs if i select it, any other selection works. Did you try this on the file yourself? Did it work for you? Charlie

ya Copy n paste, I agree it should work, at least it gives me the option of selecting SName, supplier name was not in the list before. Charlie

Did That but It may be me, I still get the #error instead of the names of suplliers, the control source in the properties of the text box is SName, is this correct. I cant understand what is wrong, I think I must have an error somewhere else. Charlie

Appreciate it. Thanks.

I have a problem, I have a combo box on a form showing supplier codes, I want to place a text box next to the combo box to show supplier name, whenever I try to do this I get an error, its strange because the text box will let me link other fields. please take a look at it here...