Embedded Macro Problem

[BartK]

Matching Text box with table

Hi all,
I'm having this problem, it's probably very simple to fix, but I'm new to Access.

I have a box that prompts me for a last name and I want to be able to return all last names that start with what I type. EX. I want to return all names that start with Appl or Bake. Here is what I have so far in my where condition =[Last Name?]=[Last Name]

Any help would be greatly appreciated.

 

[Galaxiom]

I don't do macros but the essence of any partial search is
Like [Enter Search] & "*"

 

[BartK]

Still doesn't work. I've tried several different variations of the phrase.
I'm opening a report and what I want to see is the information that I input into my text box. I have a problem in my argument of the where condition is and it is:

Where Condition = [Last Name?]=[Last Name]

this condition only gives me exactly what I type in, I need to have the wildcard operation, I"m probably not explaining myself all that well. Thanks for all the patience and the help