Hi
I've been concentrating on GIS for the past 18 months so my database skills, simple as they are, have lapsed. i am trying to do a filter search. one box is number [ccc_ref_number] the other box is text [extra_ref]. it's simple really - i want to double click the record in the open form and i want it to take me to the corrosponding record in the form "frm_estates". the seperate components of the filter criteria below works by themselves but when i combine then they do not. i'm pretty sure it's something to do with the quotation marks but god knows if i can find it. anyone have any ideas what the problem is??
DoCmd.OpenForm "frm_estates", acNormal, , "[ccc_ref_number]=" & Me.CCC_Ref_Number & "[extra_ref]='" & Me.extra_ref & "'"
thanks in advance
I've been concentrating on GIS for the past 18 months so my database skills, simple as they are, have lapsed. i am trying to do a filter search. one box is number [ccc_ref_number] the other box is text [extra_ref]. it's simple really - i want to double click the record in the open form and i want it to take me to the corrosponding record in the form "frm_estates". the seperate components of the filter criteria below works by themselves but when i combine then they do not. i'm pretty sure it's something to do with the quotation marks but god knows if i can find it. anyone have any ideas what the problem is??
DoCmd.OpenForm "frm_estates", acNormal, , "[ccc_ref_number]=" & Me.CCC_Ref_Number & "[extra_ref]='" & Me.extra_ref & "'"
thanks in advance
Glad I could help. 
