Kamis, 07 Januari 2016

Re: [MS_AccessPros] Parameter query stops working well

 

Jorge-


How are you using the query?  Is it the Record Source for a form?  What is the SQL of the query?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Jan 7, 2016, at 12:37 AM, muralles_r12@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi Folks, I hope you are doing well.

I am wondering why this happens.

I have a parameter query into which I input a customer name to get his list of properties.

I have several queries like this.

The problem I have is that after using the query a few times, it stops working.

It requires that I enter the parameter twice.

When I enter the parameter the first time, it just clears the form.

When I enter the parameter for the second time, it gives me the results.

Can someone help please?

Thanks.

Jorge Muralles







__._,_.___

Posted by: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Posting Komentar