continuous form

[edtanner]

i have access 2007 i created a continuous form based on a query that list work order numbers i placed a command button on the continuous form to open each work order but no matter witch button i clik i always open the first work order in the data base
any ideas

 

[SmallTime]

Hey,

How about:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "NameOfFormToOpen"

stLinkCriteria = "[YourLinkIDFieldOnFormToOpen]=" & Me![YourLinkIDFieldOnTheCurrentForm]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Take Care
SmallTime