ACCESS 2003 -- form and subform HELP........

I've a form in Datasheet view which have 5 fields ... Last name,
firstname, city, zipcode, phone. When the user double click on the
phone number field it will call another form which run from the query
(The query is contrain by the phone value from the main form --
[forms]![mainform]![phone]).

It's working great in Access 2000 and Access 2003. When i try to run
it on Access 2003 in XP at work. Everytime, i double click the phone
from the main form, a window popup and ask me to enter the phone
number.


Can someone help me how to correct the problem in ACCESS 2003. Thank
you in advance and hope to hear from you soon.

sorry i means it's working fine on ACCESS 97, 2000, 2002 but the same
code not work in ACCESS 2003

1- I wouldn't suggest posting the same question 5 times as you have done.
This is very impolite and will turn people off from answering your questions
at all.

2- please post the code that you are using on the doubleclick event so we
can troubleshoot it.

Daniel




" wrote:

I've a form in Datasheet view which have 5 fields ... Last name,
firstname, city, zipcode, phone. When the user double click on the
phone number field it will call another form which run from the query
(The query is contrain by the phone value from the main form --
[forms]![mainform]![phone]).

It's working great in Access 2000 and Access 2003. When i try to run
it on Access 2003 in XP at work. Everytime, i double click the phone
from the main form, a window popup and ask me to enter the phone
number.


Can someone help me how to correct the problem in ACCESS 2003. Thank
you in advance and hope to hear from you soon.

Actually, you might as well post the SQL statement for the query as well to
give us the full picture of what is going on.



" wrote:

I've a form in Datasheet view which have 5 fields ... Last name,
firstname, city, zipcode, phone. When the user double click on the
phone number field it will call another form which run from the query
(The query is contrain by the phone value from the main form --
[forms]![mainform]![phone]).

It's working great in Access 2000 and Access 2003. When i try to run
it on Access 2003 in XP at work. Everytime, i double click the phone
from the main form, a window popup and ask me to enter the phone
number.


Can someone help me how to correct the problem in ACCESS 2003. Thank
you in advance and hope to hear from you soon.

Daniel wrote:
1- I wouldn't suggest posting the same question 5 times as you have done.
This is very impolite and will turn people off from answering your questions
at all.

2- please post the code that you are using on the doubleclick event so we
can troubleshoot it.

Daniel


Didn't mean to post it 5 times. The code in the doubleclick event is
only do the open the second form which run from the query using the
value of the the main form.

DoCmd.OpenForm "form_detail"

Could you post the SQL for the query. Is there any code being run as the
form is opened (Load or Open Events or something else we should be aware of)?

Daniel



" wrote:


Daniel wrote:
1- I wouldn't suggest posting the same question 5 times as you have done.
This is very impolite and will turn people off from answering your questions
at all.

2- please post the code that you are using on the doubleclick event so we
can troubleshoot it.

Daniel


Didn't mean to post it 5 times. The code in the doubleclick event is
only do the open the second form which run from the query using the
value of the the main form.

DoCmd.OpenForm "form_detail"

Here is the query to run the sub form

SELECT Student_financial_year.last, Student_financial_year.first,
Student_financial_year.address, Student_financial_year.state,
Student_financial_year.phone
FROM Student_financial_year
WHERE (Student_financial_year.phone)=[forms]![mainform]![phone]);

It's working great in the ACCESS 2000 and ACCESS 2002. But when i'm
trying to run the same code in ACCESS 2003 in XP op. It's popup a
winder to ask the value of [forms]![mainform]![phone everytime i double
click on one of the student on the list from the main form. that's
when the subform get call to give me more detail and run the query
above.

Thanks for your help.

I'm not an SQL expert, so perhaps someone else might have a better idea of
what is wrong but I did a fast mockup on my PC and I have a slightly modify
synthax. Give it a try, hopefully it will fix your problem.

SELECT Student_financial_year.last, Student_financial_year.first,
Student_financial_year.address, Student_financial_year.state,
Student_financial_year.phone
FROM Student_financial_year
WHERE (((Student_financial_year.phone)=[forms]![mainform]![phone]));

Daniel






" wrote:

Here is the query to run the sub form

SELECT Student_financial_year.last, Student_financial_year.first,
Student_financial_year.address, Student_financial_year.state,
Student_financial_year.phone
FROM Student_financial_year
WHERE (Student_financial_year.phone)=[forms]![mainform]![phone]);

It's working great in the ACCESS 2000 and ACCESS 2002. But when i'm
trying to run the same code in ACCESS 2003 in XP op. It's popup a
winder to ask the value of [forms]![mainform]![phone everytime i double
click on one of the student on the list from the main form. that's
when the subform get call to give me more detail and run the query
above.

Thanks for your help.

Daniel wrote:
I'm not an SQL expert, so perhaps someone else might have a better idea of
what is wrong but I did a fast mockup on my PC and I have a slightly modify
synthax. Give it a try, hopefully it will fix your problem.

SELECT Student_financial_year.last, Student_financial_year.first,
Student_financial_year.address, Student_financial_year.state,
Student_financial_year.phone
FROM Student_financial_year
WHERE (((Student_financial_year.phone)=[forms]![mainform]![phone]));

Daniel



Appreciate for your helps but i don't think it was an syntax error. As
i mention the same code is working fine when i run the application in
ACCESS 2000 or ACCESS 2002. It's only popup and asking me to input
value when i run it in ACCESS 2003. It's the same application. Thanks
for trying.

On 16 Dec 2006 16:26:08 -0800, wrote:

Here is the query to run the sub form

SELECT Student_financial_year.last, Student_financial_year.first,
Student_financial_year.address, Student_financial_year.state,
Student_financial_year.phone
FROM Student_financial_year
WHERE (Student_financial_year.phone)=[forms]![mainform]![phone]);

That SQL statement has a superfluous ")" which could be a source of
trouble. Different versions of Access may respond differently to errors
such as this.

It's working great in the ACCESS 2000 and ACCESS 2002. But when i'm
trying to run the same code in ACCESS 2003 in XP op. It's popup a
winder to ask the value of [forms]![mainform]![phone everytime i double
click on one of the student on the list from the main form. that's
when the subform get call to give me more detail and run the query
above.

Thanks for your help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.