Dennis-
Yes, the field must be in the Record Source. It sounds like your combo box has
not Control Source. Is that the case?
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 3:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] To open a from with link criteria from a subform
Hi John,
but that is not the case. I.e. the combo box is bound only to one column, and
that is the very column called (Mässor Huvudtitel] containing the name of the
Trade Fair.
So I tried a "quick-and-dirty" idea: I added a new control box to the form with
the column [Mässor Huvudtitel] in the table Mässor as datasource and then used
that one in the link criteria in my VBA code. But I still got just an empty form
opened. Could it be that the field I use in my link criteria must also be a
column in the table? I.e. is it not enough if it is a control box on the form?
Kindly regards
Dennis Davidsson
11 maj 2012 kl. 14:51 skrev John Viescas:
> 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
>
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar