Open Form with Combo Box Value

[weircolin]

Hi There

Can anyone tell me why the following isn't working please?

Dim stDocName As String
Dim stLinkCriteria As String
Dim stcombo As Integer

stcombo = cboselectevent.Value

DoCmd.OpenForm "Attendee", WhereCondition:="[Event] = stcombo"





It just asks me to enter a value for stcombo

Cheers

Colin

 

[Damon Heron]

Have you tried:
DoCmd.OpenForm "Attendee", , ,"[Event] = " & stcombo

Damon

 

[weircolin]

Have now... and it worked, thank you!