Search form using value from a different form.

[Homegrownandy]

I'm trying to make a form where I can enter a few letters and it will search my jobs list and produce results which start with the value I entered.
This is what I currently have:

Like [Forms]![SchedulerMenuF]![Search_TXT] & "*"



When I run the query it gives me back all records no matter what I enter into the text box. Any one have an idea why this is?

Thank you, Andy.

[Mahendra1000]

Like "*" & [Forms]! [MainFormname]! [Yourcolumnnamehere] & "*" Or Is Null

[Homegrownandy]

Like "*" & [Forms]![SchedulerMenuF]![Search_TXT] & "*" Or Is Null

This isn't returning anything mate. No jobs are showing no matter what I put.

[Homegrownandy]

Apologies, It works perfectly but I need to save the form data first. So when I ad this to a button it should be fine.

Thank you!

Ill mark this as solved after some testing.

[Mahendra1000]

Glad it worked