OpenForm based on criteria 1

[spluim]

I am trying to open a form to display only a record with a matching intRolodex_ID.

This is my coding and it is not working. When I run the code, it does not recognize Temp. I know it is something easy but I surrender

Private Sub Command150_Click()
On Error GoTo Err_Command150_Click

Dim stDocName As String
Dim Temp As Integer

Temp = intRolodex_ID

stDocName = "frmNewPropOwnr"

DoCmd.OpenForm stDocName, acNormal, , "intRolodex_ID = Temp", acFormEdit

Exit_Command150_Click:
Exit Sub

Err_Command150_Click:
MsgBox Err.Description
Resume Exit_Command150_Click
End Sub

 

[scottian]

im having a guess here, but it looks like Temp is one of those reserved words which vba and access use. try altering the variable name to Tempj for instance and see if that works

"My God! It's full of stars...

 

[spluim]

I tried a different word but that didn't do it. I think it is the way I have expression "introlodex_ID = Temp". Should it be presented differently?

 

[Craig0201]

If you must use Temp, try surrounding it []. It works in VB.Net for naming methods and properties in classes so it's worth a go.

Craig

 

[RoyVidar]

Try:

[tt]DoCmd.OpenForm stDocName, acNormal, , "intRolodex_ID = " & Temp[/tt]

Roy-Vidar