Minggu, 23 Agustus 2015

RE: [MS_AccessPros] Parameter QUERY stops working

 

Hi Duane.

I am not sure if I explain this well.

I have a query I use to see all the records for a customer.

**********************************************

Like "*" & [ Enter Owner's Last Name ] & "*"

**********************************************

I enter the code above on the last name field.

When I run this query a form pops up and I enter the last name of the customer.

This works fine but after a while, it stops, I enter the criteria to search for, click OK and the criteria disappears but the query does not return any results.

I have to enter the search criteria again and then it does work.

This gets fixed if I go to the query in design view, cut the code above, save the query, open it up in design view and paste the code again.

Thanks for the help.

Jorge Muralles

__._,_.___

Posted by: muralles_r12@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar