Like [Forms]![VeteransDetailsF]![LastNametxt] & "*" Or Is Null

Example: if you were to type a letter (e.g. "A") in your search box you'd want the criteria to the become A* not *A*

Search As You Type
Search Form 2.0

Thank you, the videos were very helpful however i didn't get my answer. I am trying to set my criteria so when i search the last name text box for example a "B" i need it to return all last names that start with a B. What i get is every name that contains a B.
Thank you all for responding, much appreciated.

Alan show us your criteria.

If you put LastName = "B*" you will get all last names starting with B.
If you are using LastName = "*B*"  That will return any last name that has a B anywhere.

Use of wildcards in a search was covered extensively in Access Beginner 5.
You might want to go revisit that course.

I have a form with unbound text boxes that i enter the criteria to query on. I used the example in the search video to make my
database. See attachments

Below the text boxes on the main form is a subform that displays the output.

You haven't updated your search criteria

If i enter ="B*" in my criteria, i will only get Names that start with a B. I want to be able use the text box to enter on the fly what i am trying to query whether it would be A B C etc.

My first comment is the code you want to use.
I've updated my second comment, that was an example.

Alex I am an idiot, i kept all the changes you gave me  in notepad as i always do. In reviewing the examples I made a mistake in the criteria. Your code worked after applying them correctly, i wasn't paying attention to details.

Thank you very much....

Happy to help, it's easily done, lots of moving parts :-)