Solved

Clearing an unbound list box

Posted on 2008-10-17
4
256 Views
Last Modified: 2012-05-05
Experts,
The purpose of my form is to build a bill of material (BOM). The user selects a bill of material number and adds various components to it, saving a record after each new componet has been added, showing the build components in a list box. When a BOM has been completed the user then adds a new BOM and the list box needs to be cleared. And that is my problem - clearing out the list box.  
I've tried:
Me.lstBOM.Value=False
0
Comment
Question by:Frank Freese
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22742362
What is the rowsource of the listbox?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 22742411


Me.YourListBoxName.RowSource = ""

mx
0
 

Author Closing Comment

by:Frank Freese
ID: 31507191
Great! I tried that a few minutes ago and it work so you affirmed I did  the right thing
0
 
LVL 57
ID: 22742453
Try:

Me.lstBOM.Value = Null

JimD.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now