Dennis-
Probably. You have to filter the bound value of the combo box, which is not
necessarily what is displayed. For example, if it is bound to and ID field but
displays a name, you have to filter for the ID value.
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)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
Sent: Friday, May 11, 2012 2:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
Tidak ada komentar:
Posting Komentar