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

John,

I finally got it working!!!
This is what I did now: I changed the form property Data Entry to No for the form Mässor.
And my set up now is the following:
1. I added a new button on the subsubform BranscKP3 instead of using the existing one on the outer form Adressregister.
2. Instead of trying to compare the character strings of the names of the fairs I introduced a temporary test number on the form Mässor and filtered on that one.

Now I have at least something that works, and I will now try to go backwards in my various tests from yesterday trying to identify the crucial point, for which it does not work.

Thanks a lot for helping me out of this tricky situation!!

Kindly regards
Dennis Davidsson

13 maj 2012 kl. 09:40 skrev John Viescas:

> Dennis-
>
> Number? I thought you were comparing to text. Please copy and paste what was
> in the debug window in a reply. You cannot attach pictures.
>
> 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: Sunday, May 13, 2012 9:16 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] To open a from with link criteria from a subform
>
>
> John,
>
> I added the debug line to my code as you suggested, and in the Immediate window
> it showed exactly the number I expected for the filtering of the form Mässor.
> But the result is still the same! I.e. the form Mässor is opened saying it is
> filter On but all the controls on the form are empty as when in input mode for a
> new record.
> You also asked for the settings of the Link Master Fields and Link Child Fields
> of the subsubform control.
> These are: Adressnr;Kontaktpersonnr. The same for both.
>
> Kindly regards
> Dennis Davidsson
>
> 13 maj 2012 kl. 07:53 skrev John Viescas:
>
> > Debug.Print stLinkCriteria
>
> [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/