Enter Parameter?

[Guest]

Every time I use a command button to close a form that has cascading combos
in it, I receive a dialog box that asks me to enter a parameter.
This never happened in A97. I'm using AXP now, perhaps I need to modify
something differently?

the code behind the button is:
.....
doCmd.Close acForm, stDocName

My queries in the boxes are:
combo1(query):
SELECT

.[field1]
FROM

combo1 (code):
with me.combo2
.value = null
.requery
end with

combo2 (query):
SELECT

.[field2],

.[field1]
FROM

WHERE

.[field1] Like [Form]![NameOfForm]![combo1]

 

[Van T. Dinh]

It is a bug.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=811860

 

[Guest]

Thank you, that solved my problem.

It is a bug.

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=811860

--
HTH
Van T. Dinh
MVP (Access)

Every time I use a command button to close a form that has cascading combos
in it, I receive a dialog box that asks me to enter a parameter.
This never happened in A97. I'm using AXP now, perhaps I need to modify
something differently?

the code behind the button is:
....
doCmd.Close acForm, stDocName

My queries in the boxes are:
combo1(query):
SELECT

.[field1]
FROM

combo1 (code):
with me.combo2
.value = null
.requery
end with

combo2 (query):
SELECT

.[field2],

.[field1]
FROM

WHERE

.[field1] Like [Form]![NameOfForm]![combo1]