Where condition of openform not clear ? 1

[Schaap]

I got a problem with the where condition of the cmd.openform !
See code below :

Option Compare Database
Option Explicit
Dim Plaats As String

Private Sub IndexNumber_Click()

Plaats = Me.IndexNumber
DoCmd.Close
DoCmd.OpenForm "ApplicationForm", acPreview, , "IndexNumber = Plaats"

End Sub
Explanation :
I have a form where a part (selection) of the database is shown. When I click on an indexnumber the "Application Form" of that particular indexnumber has to be opened.
Instead of opening this "Application Form" I got an inputbox where I have to fill in a value for the variable "Plaats" !!! After this I get the right "Application Form" on the screen !!!
But I don't wanna see the inputbox. The meaning is that Plaats gets the value of Me.IndexNumber. When I walk through the code it will !
Something is wrong with the last DoCmd-line. How do I define the where condition, so that the value of Plaats will be checked ?

 

[RoyVidar]

Hi!

Try:
[tt]DoCmd.OpenForm "ApplicationForm", acPreview, , "IndexNumber = " & Plaats[/tt]

- i e concatenate the value into the criteria string

Roy-Vidar

 

[Schaap]

Thanx Roy-Vidar,

I know that it was something like this, but I didn't know how exactly.