Combo2 error

A

an

Hello!

I have a Form with Combo1 and Combo2.

Combo1
In RowSource:
SELECT DISTINCT [Q_Avaliation].[M_Field] FROM Q_Avaliation;
In AfterUpdate:
Me!Combo2 = Null
Me!Combo2.Requery

Combo2
In RowSource:
SELECT Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];
In AfterUpdate:
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

When click Combo1 row, change data correctly and actualize
field in Combo2 (dependents off Combo1)
When click Combo2 row, obtain compilation error
because "Method or data member not found".
I don't know why.
I need help, please.
Thanks in advance.
an
 
G

Gerald Stanley

What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
 
A

an

Thanks for your replay.
The type is Text.
an
-----Original Message-----
What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hello!

I have a Form with Combo1 and Combo2.

Combo1
In RowSource:
SELECT DISTINCT [Q_Avaliation].[M_Field] FROM Q_Avaliation;
In AfterUpdate:
Me!Combo2 = Null
Me!Combo2.Requery

Combo2
In RowSource:
SELECT Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];
In AfterUpdate:
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

When click Combo1 row, change data correctly and actualize
field in Combo2 (dependents off Combo1)
When click Combo2 row, obtain compilation error
because "Method or data member not found".
I don't know why.
I need help, please.
Thanks in advance.
an

.
Click to expand...
.
Click to expand...
 
A

an

Sorry.
RecordSource have:

SELECT [Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];

an
-----Original Message-----
What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hello!

I have a Form with Combo1 and Combo2.

Combo1
In RowSource:
SELECT DISTINCT [Q_Avaliation].[M_Field] FROM Q_Avaliation;
In AfterUpdate:
Me!Combo2 = Null
Me!Combo2.Requery

Combo2
In RowSource:
SELECT Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];
In AfterUpdate:
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

When click Combo1 row, change data correctly and actualize
field in Combo2 (dependents off Combo1)
When click Combo2 row, obtain compilation error
because "Method or data member not found".
I don't know why.
I need help, please.
Thanks in advance.
an

.
Click to expand...
.
Click to expand...
 
G

Gerald Stanley

There's your problem
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

If [N_Field] is a textbox, it won't have a RowSource property.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Thanks for your replay.
The type is Text.
an
-----Original Message-----
What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hello!

I have a Form with Combo1 and Combo2.

Combo1
In RowSource:
SELECT DISTINCT [Q_Avaliation].[M_Field] FROM Q_Avaliation;
In AfterUpdate:
Me!Combo2 = Null
Me!Combo2.Requery

Combo2
In RowSource:
SELECT Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];
In AfterUpdate:
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

When click Combo1 row, change data correctly and actualize
field in Combo2 (dependents off Combo1)
When click Combo2 row, obtain compilation error
because "Method or data member not found".
I don't know why.
I need help, please.
Thanks in advance.
an

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
A

an

Ok, Gerald Stanley!

Many thanks.
an
-----Original Message-----
There's your problem
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

If [N_Field] is a textbox, it won't have a RowSource property.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Thanks for your replay.
The type is Text.
an
-----Original Message-----
What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hello!

I have a Form with Combo1 and Combo2.

Combo1
In RowSource:
SELECT DISTINCT [Q_Avaliation].[M_Field] FROM Q_Avaliation;
In AfterUpdate:
Me!Combo2 = Null
Me!Combo2.Requery

Combo2
In RowSource:
SELECT Q_Avaliation].[N_Field] FROM Q_Avaliation WHERE
[Combo1]=[M_Field];
In AfterUpdate:
[N_Field].RowSource = "Select [N_Field] FROM
[Q_Avaliation] WHERE [M_Field] = [Combo1]"

When click Combo1 row, change data correctly and actualize
field in Combo2 (dependents off Combo1)
When click Combo2 row, obtain compilation error
because "Method or data member not found".
I don't know why.
I need help, please.
Thanks in advance.
an

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Boxes & Requery Issues 2
Combo is null 4
Undefined Function 1
Cascading Combo error 10
Cascading ComboBox 1
Reduce combo box selections 2
Enter Parameter? 2
Combo Value Depending On Other Combo Value 2

Top