Search results
-
V
GoToRecord passing a condition
Thank you for your reply. I believe I am on the right track but keep getting the error 'runtime error:3021 No current record' would you know why? Private Sub Form_Current() Dim RecordValue As String Dim rs As Object If Not IsNull(Me.Company_Name) Then RecordValue =... -
V
GoToRecord passing a condition
Is there a way where you can write some code that says: GoToRecord WHERE PrimaryKey=Variable This will then change the record displayed in main form. Any Ideas? -
V
go to record based on query selected
Thank you for that syntax correction! Such a silly mistake to make. I keep getting an error message saying record doesn't exist but not too sure why. Private Sub Form_Current() If Not IsNull(Me.Student_Name) Then Dim RecordValue As String Dim rs As Object... -
V
go to record based on query selected
I keep getting a runtime error 3077 related to the line: rs.Findfirst "[Student_Name]=" & RecordValue Would you know why? -
V
go to record based on query selected
Hello there, I am trying to switch the record selected on my main form to the one which has been selected in a sub form datasheet. Such that, as the user selects a record in the subform it will identify the Primary Key field and use that to change the record displayed in the main form. Below... -
V
Select record in datasheet view to display in main form
How would i find out the value of the unique field from clicking on the record? -
V
Select record in datasheet view to display in main form
I am creating a form which allows a user to enter information about students. On the same form, it also allows the user to enter text into a search box which will run a query and then will display the results of the query at the bottom of the form in a subform (as a datasheet). I am trying to...