Basic Search Form Inquiry

[Qualinwraith]

Greetings, I'm a bit new to the world of MS Access and have encountered a problem when making a search form for my database. The query is using a Like Condition with the '*' Wildcard for a single field like so:

Like "*" & [Forms]![frmPickUpReport]![txtAgentName].[Text] & "*"

While the query on its own runs correctly from the viewer of course prompting me to enter the data manually the actual data from the form is being ignored. Instead of taking the text value within my form's text box, when I press the report creation button the same data box is prompted to me asking for me to enter the data manually.

anybody has a solution?

I'm using MS Access 2000 and cannot use any other application such as visual studion

 

[MStef]

Try this;
Like "*" & [Forms]![frmPickUpReport]![txtAgentName] & "*"

Be sure that you write formName and field name correct,
be sure the form is open.

 

[Qualinwraith]

Date search Problem

Thanks for the reply, it worked perfectly but now I have another bugging problem. I need to maek a query that performs a search by using a date. The Date is in the format:

12/12/2005 15:26:00

MS Access is telling me that the query is too complex and unfortunately I cannot change the format of my data

Any views?

 

[MStef]

Look at "DemoQDateA2000.mdb"