SubForm Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Subform and all the records come when I run it alone. But when I run
a one of my Forms, wich calls the subform, a message comes:

Data out of range

and after I click OK:

ODBC call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] The conversion of a char
data type to a
datetime data type resulted in an out-of-range datetime value(#242)

1. I tried to take off the link child feild, and the link master field.
2. I tried to set the recordsource by VB (for the Form and the Subforms).
3. I tried to make others subforms for the problematic Form.

I can't think more...

For any ideas I'll be thankfull.
 
If the form run fine by it self, then the problem should be in the link
between the form and the sub form, or the problem is with the form it self.
did you try running the main form by it self, without the sub form?
 
Well, I tried to take off the link, and still didn't work.
Also, I tried to take off the subforms and because the subform was the most
important thing in the main form, that wasn't the problem.
!!!! I don't know anymore.
!!!!! I tried almost everything.
And what I don't understand is, the structure that I used, is also used in
others forms.

Thanks for your help, but you have others ideas???

Hanna

"Ofer" escreveu:
If the form run fine by it self, then the problem should be in the link
between the form and the sub form, or the problem is with the form it self.
did you try running the main form by it self, without the sub form?

Hanna said:
I have a Subform and all the records come when I run it alone. But when I run
a one of my Forms, wich calls the subform, a message comes:

Data out of range

and after I click OK:

ODBC call failed
[Microsoft][ODBC SQL Server Driver][SQL Server] The conversion of a char
data type to a
datetime data type resulted in an out-of-range datetime value(#242)

1. I tried to take off the link child feild, and the link master field.
2. I tried to set the recordsource by VB (for the Form and the Subforms).
3. I tried to make others subforms for the problematic Form.

I can't think more...

For any ideas I'll be thankfull.
Click to expand...
Click to expand...
 
Back
Top