Strange parameter value

G

Guest

Hi all,

I have a form that opens another form on the event "OnCurrent",it was
working very well ,but now when i open the first form i must get first a box
to enter aparameter value ,although i have never set a parameter value for
the query that works as the recordsource of the form.
Add to this also that this parameter value box does not reuire any value
to enter inside , as whether i click on "ok" or "cancel" i can enter to the
second form and to the same predetermined "WHERE conditionCan anybody help me
?!
 
G

Graham R Seach

Hi again Pietro,

You have a mispelled field either in code, the query, or in the
ControlSource or RowSource of one of the controls. When the Parameter box
comes up, press Alt+Break, go into Debug mode if Access allows you to, and
find the problem in the code (if that's where it is). If that's not the
case, then you'll have to check the ControlSources and RowSources until you
find the problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

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

Parameter Value error in a Subform 0
Query Parameter using multiple options 0
Enter Parameter Value in Access Form 0
Enter Parameter Value box 2
form to enter parameter values delays display report and subrepor 2
Error 3331 & validation rule error 1
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Parameter Query 2

Top