46
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.
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)
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.
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.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (