2k form will not open in 97 (1 Viewer)

durdle

Registered User.
Local time
Today, 17:05
Joined
May 7, 2002
Messages
130
Hey,

I converted my db from 2000 to 97. When I open it in 97, the form gives me the following error message:

"ms access can't open the form name"
its contains data that ms doesn't recongize. re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form.

I have nothing fancy on the form, just a few combo boxes. Just wondering if anyone has any advice. I have attached the db's in 2K & 97.
Note: I get the error when I convert it to 97 and then try to open it in 97.

Thanks
________
ford xw falcon
 
Last edited:

durdle

Registered User.
Local time
Today, 17:05
Joined
May 7, 2002
Messages
130
I have it fixed now.

Thanks Anyhow.
________
honda rc71
 
Last edited:

durdle

Registered User.
Local time
Today, 17:05
Joined
May 7, 2002
Messages
130
Hey,

I thought my problem was fixed but it's not. Below is the form_load code that will not allow me to open the form in Access 97. I get the application error message and the dr. watson closes access. I have no trouble opening the database but when I try to load the form I get the error message.

Any help would be great.

Private Sub Form_Load()

'Clear all the input fields and unlock question 4's textboxes

cbotrainer.Value = ""
txtDate.Value = ""
cboweek.Value = ""
cboans1.Value = ""
Comments1.Value = ""
cboans2.Value = ""
Comments2.Value = ""
cboans3.Value = ""
Comments3.Value = ""

Topic4_1.Value = ""
cboQ4Ans1.Value = ""
A4_1Comments.Value = ""

Topic4_2.Value = ""
cboQ4Ans2.Value = ""
A4_2Comments.Value = ""

Topic4_3.Value = ""
cboQ4Ans3.Value = ""
A4_3Comments.Value = ""

Topic4_4.Value = ""
cboQ4Ans4.Value = ""
A4_4Commnets.Value = ""

Topic4_5.Value = ""
cboQ4Ans5.Value = ""
A4_5Comments.Value = ""

Topic4_6.Value = ""
cboQ4Ans6.Value = ""
A4_6Comments.Value = ""

Topic4_7.Value = ""
cboQ4Ans7.Value = ""
A4_7Comments.Value = ""

Topic4_8.Value = ""
cboQ4Ans8.Value = ""
A4_8Comments.Value = ""

Q5Fav_1.Value = ""
Q5Fav_2.Value = ""
Q5Fav_3.Value = ""
Q5Fav_4.Value = ""


Q5LFav_1.Value = ""
Q5LFav_2.Value = ""
Q5LFav_3.Value = ""
Q5LFav_4.Value = ""

End Sub
________
vaporizer reviews
 
Last edited:

Mile-O

Back once again...
Local time
Today, 17:05
Joined
Dec 10, 2002
Messages
11,316
These five lines could replace every line of the code above - for starters.

Code:
On Error Resume Next
Dim ctl As Control
For Each ctl In Me
    Ctl = vbNullString
Next


More importantly, why would you have to clear a record's values when you open a form? :confused:
 

Users who are viewing this thread

Top Bottom