ListBox To Display Specific Records From Table

[ODR via AccessMonster.com]

Hi,

The application i am building is to be used for storing parts. Two of my
columns in my table are the following.

MinStockLevel
QtyInStock

When the QtyInSock value falls below the MinStockLevel I want these rows to
be displayed in a list box. Please bear in mind that the MinStockLevel will
be different for each item stored in the table.

Can anyone give me some pointers

Thanks
Sean

 

[Al Campagna]

ODR,
Your Listbox has a RowSource property, where you create a query that
will deliver justbthose records you need.
In this case, your QtyInStock field should have the following
criteria...
<[MinStockLevel]
(assuming that this is the actual on hand qty at run time)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[ODR via AccessMonster.com]

Al Campana,

Thanks
Simple answer, i was looking at it to deeply. Too much coffee i think!
cheers
Sean

ODR,
Your Listbox has a RowSource property, where you create a query that
will deliver justbthose records you need.
In this case, your QtyInStock field should have the following
criteria...
<[MinStockLevel]
(assuming that this is the actual on hand qty at run time)

Hi,

[quoted text clipped - 14 lines]

Thanks
Sean