-------- Originele bericht -------- Onderwerp: Re: [users] Base: "Input Parameter" window pops up also when "fill parameter"-macro is in place Van: Drew Jensen <[email protected]> Aan: [email protected] Datum: thu, 25 dec 2008 14:07:57 -0500
> Erik Remmelzwaal wrote: >> All, >> >> I've a Base document with a form and a sub-form. The content of the >> sub-form is based on a query. This query contains two parameters. One >> parameter is solved via Linked fields setup of the Data properties of >> the sub-form. >> The other parameter is resolved via pop up window "Input parameter". I >> try to prevent this pop up by adding a macro to the 'Fill parameter' of >> the events properties of the sub-form. This does not happen. First the >> pop up window appears and than the macro is executed. I can change the >> value of the parameter in the macro and overrule the value in the pop up >> window. >> >> Does any one have a suggestion how to prevent the occurring of the pop >> up when a macro is in place? >> > > Hello Erik, > > Well, yes I have an idea. > > First you need to get rid of that named parameter. > It is a long standing situation that you can not get in front of the UI > asking for the value for those - But do not fear you can still get the > functionality you want in your macro, you just need to tackle it from a > slightly different angle. > > Anyway - I believe there is already a good example of what you need to > do on one of the web forums. I'll look a little later today for you - if > I don't come up with it then I will post one up there and either way > place a reference to the post on the list here. > > Till a little later then - and Merry Christmas, > > Drew > Hi Drew, Thanks for the hint. I started looking for other keywords and found indeed some examples on filtering, linking main/sub forms etc. I liked the parameter because I'm expecting that filters are not put into the the database query but solved locally, hence to much data is read from database. Regards, Erik --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
