Notifications
Announcements
No record found.
Hey how r you?Is there any one?I want to get filter data on JBN pls guide me anyone?I want When, I click on check box then record filtered show. In this time all JBN show in pic but, I want click check box show limited record like posted show.list mention below in Image.
You screenshot shows a lookup of JournalNum field. Does it mean that you want to filter records in the lookup form ands not in the grid of Payment journal form?
yes it's a lookup field but I want when i click on check box button then show only posted record that mention in image or blue circle.
Thank's Martin Drab for response.
You won't do anything when the checkbox is ticked, because that's not when the lookup is shown. What you need to do is adding a query range when building the lookup. If you aren't familiar with lookups, look at How to: Add a Lookup Form to a Control, and notice how they added the range for CustGroup field.
I am familiar with lookup, but I want when I click on check box then relevant JBN number linked with checked/Posted that shown or unchecked JBN not show.
Thanks
It's difficult to guess that you already know and what you're struggling with if you just describe the whole scenario and don't ask questions.
If you know that you must modify the lookup and you know how to use query range, then what exactly you need? Are you saying that you are actually unable to design the righ database query? If so, you should have told us!
Unforunately it's not clear to me what you mean by "relevant JBN number linked with checked/Posted that shown". Please elaborate.
Okay I'll send you screen shot and then explain.
If I'm not wrong, you have records(dataSource) at the form and When you click (the new unbound checkBox), you want saw filtered records.
Then, you can add a range to form datasource. You can add range at Ds.executeQuery (before super) but you must call executeQuery from checkbox (you can call it fromm clicked or modified)
Just dont forgot executeQuery can be called from other methods so you must manage your range (use findOrCreateRange and clearRange)
Thanks for response. I will try.
If you send me any sample using picture.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
