«

I've got a LastName textbox and a FirstName textbox.

How do I make LastName mandatory, and FirstName optional ?

If I use Select..........Where (LastName=?) AND (FirstName=?)
i need input from both textboxes, and if I use OR- it is either.

May be you can use something like
Select..........Where (LastName=?) AND (FirstName=?+%)

So if the first name is blank the query will get all the Firstnames

"" wrote:

> I've got a LastName textbox and a FirstName textbox.
>
> How do I make LastName mandatory, and FirstName optional ?
>
> If I use Select..........Where (LastName=?) AND (FirstName=?)
> i need input from both textboxes, and if I use OR- it is either.
>
>
>