Open form to correct record from datasheet
Open form to correct record from datasheet
(OP)
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????
RE: Open form to correct record from datasheet
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
RE: Open form to correct record from datasheet
Dim WhereClause as String
Sorry if it caused a problem.
RE: Open form to correct record from datasheet