Unanswered: Access 2000, Where Clause or FindRecord
I have a DB with 8 forms and a switchboard for tracking project information. I have a "Jump To" Combo Box on each form with the purpose of opening another form, and going to the "Project_Number" (field) on the opened form that matches the same filed on the current form (ie, Project_Number 4138 is selected on my "Funding" Form, I want to open the "Design" Form and go to Project_Number 4138.) Here is what I have tried:
Dim stDocName As String
Dim stLinkCriteria As String
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!