mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 9:40 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Limiting Subform View
PostPosted: Thu Aug 02, 2012 3:32 pm 
Offline

Joined: Thu Jun 21, 2012 11:13 am
Posts: 272
Country: France (fr)
Hi everyone,

I want to limit a subform view so that it only displays the customers whose No. is equal or greater than a certain value....

How can I do that???


Top
 Profile E-mail  
 
 Post subject: Re: Limiting Subform View
PostPosted: Thu Aug 02, 2012 4:55 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7501
Location: Milan
Country: Italy (it)
If you have a fixed value, you can put it in the filters.


But I suppose it is a value given by the main form.
So in the subform, you need to create a function that receives that value:
Code: Select all
Function InputParameters(TheValue)
BEGIN
  SETFIELD("Some Field",'%1..',TheValue);
  CurrForm.UPDATE(FALSE);
END;


You also need to give a name to your subform in the main form.
And in the main form, you need to call the function. Generally done from the OnAfterGetCurrRecord-trigger (and NOT OnAfterGetRecord!)
Code: Select all
CurrForm.SubForm.FORM.InputParameters('Some Value');

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 14 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: