I want to have a user "double-click" on a field or two in a record in a form that is in datasheet view (actually it is a subform) and have an entirely different form open to that record. Any thoughts? I have tried using CurrentRecord in a few different ways, but it is not working????
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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open form to correct record from datasheet 1
- Thread starter MichelleB
- Start date
-
1
- #2
Code behind the Double Click event.
Dim DocName As String, YourVariable as String, Quote as String
QUOTE = Chr$(34) '- double quote for text fields, numeric omit
YourVariable = Me.YourVariable
DocName = "YourForm"
WhereClause = " yourKey = " & QUOTE & YourVariable & QUOTE
DoCmd.OpenForm DocName, , , WhereClause
Make sure the form you are opening has allow filter on. This will open your form with the one record that you double clicked on. If you want all the records then just open without the filter (where clause).
Jerry
Dim DocName As String, YourVariable as String, Quote as String
QUOTE = Chr$(34) '- double quote for text fields, numeric omit
YourVariable = Me.YourVariable
DocName = "YourForm"
WhereClause = " yourKey = " & QUOTE & YourVariable & QUOTE
DoCmd.OpenForm DocName, , , WhereClause
Make sure the form you are opening has allow filter on. This will open your form with the one record that you double clicked on. If you want all the records then just open without the filter (where clause).
Jerry
- Thread starter
- #4
- Status
Similar threads
