DoCmd Openform Properties

[jsanders]

Good Morning All,

Can anyone tell me what the stLinkCriteria does in this statement?

 Dim stDocName As String
  Dim stLinkCriteria As String

    stDocName = "Orders"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Thank you,
Joe

 

[Rich]

Nothing, other than open the form

 

[DanR]

Based on the number of columns after the form name, it should be a where condition to limit the range of records to be opened with the form.

For example it could say Price < 50 or Status = "sold"

Have a look at the help for docmd.openform which shows the syntax

 

[jsanders]

Thanks Guys.