Infamous 'Undefined function' with query

[google3luo359]

I have an update query as follows:

UPDATE AEP SET AEP.Grade = [Forms].[frmPass].cboStudNum.Column(2)
WHERE (((AEP.Grade) Is Null) AND
((AEP.StudNum)=[Forms]![frmPass]![cboStudNum]));

When I run it I get the following error:

Undefined function ' [Forms]![frmPass]![cboStudNum.Column(2)] ' in
expression.

cboStudNum is a combo with three columns.
Widths ares 1",0",0".

I need to take the value from the third column and throw it into table
AEP.

Any ideas how I can get this to work?

TIA Ric

 

[google3luo359]

And with [Forms]![frmPass]![cboStudNum.Column(2)]

I get: 'Invalid bracketing of name'


Hope this gives more clues. Ric

 

[Rick Brandt]

I have an update query as follows:

UPDATE AEP SET AEP.Grade = [Forms].[frmPass].cboStudNum.Column(2)
WHERE (((AEP.Grade) Is Null) AND
((AEP.StudNum)=[Forms]![frmPass]![cboStudNum]));

When I run it I get the following error:

Undefined function ' [Forms]![frmPass]![cboStudNum.Column(2)] ' in
expression.

cboStudNum is a combo with three columns.
Widths ares 1",0",0".

I need to take the value from the third column and throw it into table
AEP.

Any ideas how I can get this to work?

TIA Ric

A query can't use the .Column() property directly. Try wrapping the form
reference in Eval().

 

[google3luo359]

A query can't use the .Column() property directly. Try wrapping the form
reference in Eval().

Thanks Rick! I got it working now.
And let's also bless Stephen Lebans and Google. For it came to pass on
Sat, Jun 5 1999 at 12:00 am that he explained to another desperate
soul how to get around this problem.

Ric