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

John,

The combo box has the column [Mässor Huvudtitel] in the table Mässor as Control source.
And has as Record source the query:
SELECT [Mässor Huvudtitel] FROM Mässor
ORDER BY Mässår DESC

And I cannot find anything wrong with that. It works fine when I open the form Mässor from scratch, i.e. without using the button on the form Adressregister.


Kindly regards
Dennis Davidsson

11 maj 2012 kl. 15:31 skrev John Viescas:

> 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
>
>



[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/