Search results

Hi im having a bit of trouble, in that i'm not sure how to do this. I've attached a screen shot of my form, basically, i've set up a combo box in the form header, and i've got it to list all the child's name via a select command: SELECT ChildFirstName+" " & ChildLastname AS FullName FROM...

Hi i'm having trouble, passing the subform total onto the main form, i've managed to do it when just using one subform by using: =[frmInvoicePayments Subform].Form!InvoiceTotal but now i've got 2 subforms. one is a year subform, the other subform allows me to enter different statement...

Hi i'm having problems with a query, as it seems to be returning the autonumber value on a query. Basically i have 2 tables. tbl Referrer, which has fieldnames: referrer_id (autonumber) referrer_maincontactname (text) referrer_mainbusiness (number) referrer_secondarycontactname (text)...