Search results

Come on guys, can anyone help me out with my subform search problem? Mikie

So has anyone got any ideas, if there are 2 children listed on tblChild, how to i set focus on the 2nd childs ChildID, as in the example below: Child ID...ParentId......Forename.....Surname 378...........45.............John.........Smith 45.............45............Jane..........Smith like i...

I know what access is doing, and i think i'm not using the correct field. Child ID ParentId Forename Surname 378...........45.............John.........Smith 45.............45............Jane..........Smith In the example above, if i was trying to select John Smith (who is a child), access...

I knew i was getting excited too soon, a problem has come up. If a parent has 2 children, access doesn't link properly to that record, im so close to cracking this, below is what the data looks like on tblChild Child ID ParentId Forename Surname...

i've sorted it, sort of :), i've got it to search the subform now. i changed the rowsource on the combo box to: SELECT tblChild.ChildID, tblChild.ChildFirstName, tblChild.ChildLastname FROM tblChild; instead of SELECT tblChildFirstName+" " & ChildLastname AS FullName FROM tblChild ORDER BY...

erm, you've lost me sort of, the relationships are all set up correctly as far as i know, but my database, the parents and the children, may have different surnames etc, so the user may only have the child's name to go off, so thats why i'm trying to set up a search combo box, to search the...

Hi Pbaldy i did what you said and i was able to create a combo box that searched the main form, and even jumped to that record, so then i tried to re-create that by modifying the code, to work on the subform, but it keeps coming up with an error, this is the code i get that the combo box wizard...

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...

Thanks Curtis, worked a treat, i've never used the "expression builder", could never get my head round it, but the penny's dropped at last thanks again Mikie

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 Ian your a genius, thanks for helping me out, i'm fairly new to access, and i've never used that SELECT command before, but i understand it a bit better now. As for why i have both business names in the query, i thought you had to have all the fields listed in the query for the query to...

Hi Ian a fellow geordie lol, anyways the field names you mentioned don't exist [referrer_mainbusinessname],[referrer_secondarybusinessname] so how can it be them?

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)...