SubformName.Form.RecordSource

Value From a Form
Value From Subform

LOL.. posted too quick, must have been figure / text blind.

I replaced the subform ( which was a query ) with just a continuous form and now it works... Doh..

This is helping a member of my team so much work looking up parts manually from a manual... Thanks Again.

Hi Kevin, Thanks for the reply.. Havent had email advising you had yet..lol

I will review your comments for learning.

Scrub all that, been on this all day importing parts manual and designing it, add to existing Access. Its 8.30pm in UK. Its not working, will review Kevin advices tomorrow.

Eventually I got there, changing subform to a query, continuos form etc I ended up with this working in a subform..
Me.RecordSource = "SELECT * From ManufaturersParts " & _
    "WHERE Partnumber LIKE ""*" & SearchBox.Text & "*"""
SearchBox.SetFocus
SearchBox.SelStart = Len(SearchBox.Text)

Then the unbound text box on the main form

Me!ManufaturersPartsF2.Form.RecordSource = "SELECT * From ManufaturersParts " & _
    "WHERE Partnumber LIKE ""*" & SearchBox.Text & "*"""
SearchBox.SetFocus
SearchBox.SelStart = Len(SearchBox.Text)

The ManufaturersPartsF2 is the name of the subform and what confused me I had to put an ! after Me and not a fullstop for record source.