473,386 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Listbox contains only those records that match value in TextBox field

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?

Thanks!!
Aug 30 '19 #1
1 1157
NeoPa
32,556 Expert Mod 16PB
Hi.

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.
Sep 3 '19 #2

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

Similar topics

5
by: Aaron C | last post by:
Hi, I'm trying to do an insert with the following statement: INSERT INTO user VALUES ( 'ag@ag.com','ag','Aaron','Chandler','','','La Mirada','CA',90638,714,'',''); and I'm getting the error...
3
by: RRT | last post by:
I have an existing table which describes Streets and sections of streets between intersections: Table 1: Streets by Intersections Street Area Ann St. Main to Jackson...
2
by: donnet | last post by:
Inside my .aspx file, I have a textbox populated with data from a dataset like this: <asp:TextBox text='<%# DataBinder.Eval(Container.DataItem, "Comment")%>' id="CommentText" runat="server"...
2
by: Joost Kraaijeveld | last post by:
I have a table with column1, column2, column3 and column4. How do I get all records, sorted by column4 that have the same column1,column2 and column3? TIA Joost ...
3
by: brian.a.kennedy | last post by:
I am a rookie and am looking to create records based on a field value. For example - I currently have sales data for three employees: Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I...
7
by: NoviceProgramer | last post by:
Hi Every body I have a query that outputs students names on certain criteria I want to collect these names in a single textbox in a form(separated by space or dash) the number of records varied...
2
by: nethravathy | last post by:
Hi, The following table namely elcbtripselect contains 5147 records.I want to know wether this table contains duplicate records or not. I tried with following query 1)SELECT...
16
bugboy
by: bugboy | last post by:
I'm running a query on a table with two foreign key columns- wID and dID which define a many to many relationship. I know the value of two different wID's ( wID=1, wID=2) and I need to find only the...
9
by: keydrive | last post by:
There must be a difference between a standard input field and a textbox field. I would like to use a textbox field and save the value in a hidden field for paging. This works in a default input...
1
by: whytfang | last post by:
I have a form bound on a table. This table contains student records. If i search for a student, i have to search sequentially and it is time consuming since i am keeping a record of 300 students....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.