form linking

[JJ]

Can anyone point out my problem here? I'm using this procedure to open a new form and go to the record with the same value as the one I've clicked. It opens the new form, but doesn't go to the record, just opens blank. Thanks.

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "View Client Info"
stLinkCriteria = "[ClientID]=" & Me![ClientID]

DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria

 

[Travis]

Check to make sure that Me![ClientID] is a field on your form (or at least part of the recordset). Then make sure the [ClientID] is a member of the recordset of the form your opening. And Last make sure that there is a record that meets your criteria in the new form you are opening. And last make sure that your form is not set for DataEntry (see the properties for this).