By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,819 Members | 1,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,819 IT Pros & Developers. It's quick & easy.

Listbox contains only those records that match value in TextBox field

P: 1
My MS Access app shows information about payees including the recurring day of the month payments are due for each payee. I want to limit the payees listed to only those whose payment day of the month matches the day of the month value in a ListBox on the same form (Example: Today is 8/30/2019 - so the day of the month value is 30. I have to pay 2 different payees on the 30th of each month, so the values in my PayeeTable for DueDay for each these payees is 30. The ListBox must only show these payees because of today's date).

How would I set up my ListBox to only show the correct records?

2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,470

Have a look at Example Filtering on a Form and let us know what you do and don't understand about it. It should be all you need to know, but then we don't know how experienced you are so let us know and we can take it from there.

I should add that a ListBox is not the same as a Form, obviously, but the concepts are very similar.
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.