By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

runtime error 438 after importing project

P: n/a
Me Again,
I just imported a working project from an SQL server based setup to an Access
based setup, and now this code is giving me a 'runtime error 438 not
defined' message :

Private Sub Combo108_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.Find "STUDENT_ID = " & Str(Nz(Me![Combo108], 0)) <----bookmark of
error
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
DoCmd.requery "Combo108"
End Sub

I pretty sure this is a screwed up reference, but I can't seem to find it.
Any Ideas?

--
A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
Murphy

Message posted via http://www.accessmonster.com
May 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Sorry,
Make that 'Runtime erros 438: Object doesn't support this property or method'.
...

serviceman wrote:
Me Again,
I just imported a working project from an SQL server based setup to an Access
based setup, and now this code is giving me a 'runtime error 438 not
defined' message :

Private Sub Combo108_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.Find "STUDENT_ID = " & Str(Nz(Me![Combo108], 0)) <----bookmark of
error
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
DoCmd.requery "Combo108"
End Sub

I pretty sure this is a screwed up reference, but I can't seem to find it.
Any Ideas?


--
A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
Murphy

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 13 '06 #2

P: n/a
Got it.
It isn't 'Find' but rather 'FindFirst'....

serviceman wrote:
Sorry,
Make that 'Runtime erros 438: Object doesn't support this property or method'.
..
Me Again,
I just imported a working project from an SQL server based setup to an Access

[quoted text clipped - 14 lines]
I pretty sure this is a screwed up reference, but I can't seem to find it.
Any Ideas?


--
A $300 dollar picture tube will protect a 10 cent fuse by blowing first-
Murphy

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200605/1
May 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.