Open specific record of form

[bknight]

I didn't see this anywhere. I have a query that feeds a form.

Code: Select all

SELECT (Year([Filled])) AS [Year], (Month([Filled])) AS [Month], Sum(Trades.Dividends) AS Dividend
FROM Trades
GROUP BY (Year([Filled])), (Month([Filled])), Trades.Type
HAVING ((((Year([Filled])))=2024) AND ((Trades.Type)="Dividend"));

There is a code to open the form once the main form opens

Code: Select all

Private Sub Form_Load()
    DoCmd.OpenForm "frmOpenPositionsFirst", view:=acFormDS
    DoCmd.OpenForm FormName:="frmDividends", view:=acFormDS
    DoCmd.OpenForm FormName:="frmDivByMonth", view:=acFormDS
    DoCmd.OpenForm FormName:="frmDivByMonth_Previous_Year", view:=acFormDS
    DoCmd.SelectObject acTable, , True
    DoCmd.Minimize
End Sub

The command is " DoCmd.OpenForm FormName:="frmDivByMonth", view:=acFormDS"
It opens and the first field of the first record is displayed, I guess by default.
So I would like the form to pen displaying the third field in the last record.
what commands would be best to make this happen?

[HansV]

Let's say the control bound to the third field is named Dividend.
Below the line

Code: Select all

    DoCmd.OpenForm FormName:="frmDivByMonth", view:=acFormDS

insert:

Code: Select all

    DoCmd.GoToRecord Record:=acLast
    Forms!frmDivByMonth!Dividend.SetFocus

[bknight]

I'll try that tomorrow morning.

[bknight]

OK, worked great.
Thanks

[HansV]

Good to hear that.