Reference to surname only

[GirlBlonde]

Hi i have to refer to a client name from another form and the problem i am having is the name on the refered form is John Smith, however the information for the next form i want to bring up has 2 john smiths but one has a middle initial in it, so only one record is being brought up not the two relating records.

how can i bring up both records in this instance. i can not seem to do a like *forms![form]![field] in the query.

greatly appreciate any help.

Energy & persistance conquer all things!

 

[Remou]

Try:

Like "*" & Replace(forms![form]![field]," ","*") & "*

 

[GirlBlonde]

thank you worked!

Energy & persistance conquer all things!