Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FindFirst Method Problems

Status
Not open for further replies.
iccpm

iccpm

MIS
Apr 22, 2000
17
0
0
US
I am using the finfirst method as an after update event to set the active record from a query recordset. I am connecting through ODBC to a SQL server, which is a new thing, and suddenly having big problems with this one form. The form also includes a subform, that looks at the related records in a secondary table. Sometimes the active record/bookmark appears to lose the record, and the other events designed to update the values in the form and then update the row to the table fail at that point.
any advice? Is this Access, or is it an ODBC function? I know that I can no longer lock all the records using ODBC.
 
Status
Not open for further replies.

Similar threads

JoPaBC
  • Locked
  • Question
Method '~' of object '~' failed
2 3
Replies
41
Views
342
JoPaBC
JoPaBC
JoPaBC
  • Locked
  • Question
Method 'Open' of object '_Recordset' failed 1
Replies
3
Views
64
JoPaBC
JoPaBC
VicRauch
  • Locked
  • Question
Looking for a method to display a one year calendar driven by defaults and user input
Replies
0
Views
34
VicRauch
VicRauch
WomanPro
  • Locked
  • Question
How to use contains method to a specific field value in a list? 1
Replies
3
Views
63
WomanPro
WomanPro
gmmastros
  • Locked
  • Question
Internationalization problems
Replies
12
Views
74
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top