Hello
Access 2003. I have a query with the following parameters.
Like [Forms]![Search].[txtAAID] & "*" ‘Data are in TAA
Like [Forms]![Search].[txtBBName] & "*" ‘Data are in TBB
Like [Forms]![Search].[txtCityName] & "*" ‘ Data are in TCity
Between [Forms]![Search].[txtFirstYear] And [Forms]![Search].[txtSecdnYear]
‘Data are in TYears
Like [Forms]![Searc].[txtSpWrds] & "*" ‘Data are in TWrds

All fields in tables are string and the db is relational.

I have 5 txtboxes to enter data. To enter data in Yyear parameter I have two
textboxes.

Here is the problem I need to fix
If I enter data in txtAAID nothing happens
If I enter data in txtBBName nothing happens
But
If I enter data (years) in the between parameter the query displays data but
If I enter data in the other boxes it works. How can I solve these problems?
Also I would like to enter data in the boxes without the years.

With txtCityName and txtSpWrds parameters I need to enter one or more
data.(string.) I don’t know to do it without including two or more data.

Your help is really welcome