Re: [MS_AccessPros] To open a from with link criteria from a subform

Thanks Graham and John for your suggested solution to my problem!
It solved my syntax problem correctly.
However, then coming one step further in my debugging I immediately ran into the next problem:
I got my form Mässor opened ok. Fine so far.
But, instead of, as I had expected, getting the form opened filtered by the name of the Trade Fair 'BRAU Beviale' , I just got the form opened with the combo box called (Mässa Huvudtitel] (and all other controls on the form as well) empty!
I have checked in the tables that I should get a match on the used value, so the problem is not as simple as that.
So my question is: Do I have to modify my sentence stLinkCriteria in some way, because it is a combo box rather than an ordinary control box?

Kindly regards
Dennis Davidsson

11 maj 2012 kl. 12:48 skrev John Viescas:

> Dennis-
>
> You must enclose the criteria string in quotes. Try this:
>
> stLinkCriteria = "[Mässa Huvudtitel]=""" & _
> [Forms]![Adressregister]![Kontaktpersoner]![BranschKP3].[Form]![Bransch] &
> """"
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> --------------
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
> Sent: Friday, May 11, 2012 12:20 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] To open a from with link criteria from a subform
>
>
>
> Hello,
>
> Trying to open another form from my primary form by clicking a button I get the
> following error message from Access , which I cannot figure out how to correct:
>
> Syntax error(operator missing) in the query expression '[Mässa Huvudtitel]=BRAU
> Beviale'
>
> The character string value 'BRAU Beviale' is the name of a Trade Fair and it is
> correctly obtained from the reference to a value in a combo box in a subform of
> a subform in the piece of code below.
>
> What is wrong with my piece of VBA code behind the button?
> The code is as follows:
>
> Private Sub Mässor_Click()
> On Error GoTo Err_Mässor_Click
>
> Dim stDocName As String
> Dim stLinkCriteria As String
>
> stDocName = "Mässor"
> stLinkCriteria = "[Mässa Huvudtitel]=" &
> [Forms]![Adressregister]![Kontaktpersoner]![BranschKP3].[Form]![Bransch]
> DoCmd.OpenForm stDocName, , , stLinkCriteria
>
> Exit_Mässor_Click:
> Exit Sub
>
> Err_Mässor_Click:
> MsgBox Err.Description
> Resume Exit_Mässor_Click
>
> End Sub
>
> Kindly regards
> Dennis Davidsson
>
> [Non-text portions of this message have been removed]
>
>



[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/