Help with VBA Code, from Report to Form to Sub Form

[fjcunninghamjr]

Hello and thanks for taking a look. Frank


On a Report I have an OnClick event on the “Description” control that opens “Add Clients” form that matches the CustomerID of the Report to the Form (Add Clients). This works!
Second, Closes the Report. This also works!
Third, Goes to the control “CustomerContactF” This is a continuous sub form on the Add Clients form. This works.
Fourth, Goes to the control “Description” which is a field inside the “CustomerContactF”, this is placing the cursor at the beginning of the Subform (they are in date order). I am looking to have the cursor placed on the ‘Description” row of the click from the above Report
The DoCmd.FindRecord seems to be ignored. No error messages, but open on the “Description” line at the beginning.

Private Sub Description_Click()
DoCmd.OpenForm "Add Clients", , , "CustomerID=" & CustomerID
DoCmd.Close acReport, "CLIENTS FOLLOW-UP CONTACT"
DoCmd.GoToControl "CustomerContactF"
DoCmd.GoToControl "Description"
DoCmd.FindRecord "Description"
End Sub

[orange]

Reports are typically meant for reading or printing. Forms are used for interaction with the user.
Why are you using Report for interaction?

[Welshgasman]

How are you meant to find something with Description in it?
I would expect at least "Description = " & <YourDescription Value>
https://learn.microsoft.com/en-us/of...cmd.findrecord Even then you need to search for the value, not the name of the control?

I would use FindFirst.

I just tested it on a subform in my form on a command button on the mainform, so pay attention to the syntax. Do NOT just copy as it is.

Private Sub cmdDaily_Click()
    TempVars("WeekNum").Value = DatePart("ww", Me.cboDates.Column(1))
    DoCmd.OpenForm "frmDailyList", acFormDS, , , , acDialog
    Me.sfcsfrmDaily.Form.Recordset.FindFirst "DailyID = 2037"
End Sub

[fjcunninghamjr]

Hi,
True about reports, but I always open in Print preview. I find it easier to just click an item on the report to go where I need to go on a particular form.

[Welshgasman]

To each their own.

[Gicu]

Try this please:

'.........
DoCmd.FindRecord Me.Description ' your original code was looking for the word "description" not the value of the Description textbox on the report

Cheers,