Combo2 error

  • Thread starter Thread starter an
  • Start date Start date
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
 
What type of control is [N_Field]? Does it have a
RowSource property?

Hope This Helps
Gerald Stanley MCSD
 
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...
 
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...
 
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...
 
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...
 
Back
Top