Solved

Clearing an unbound list box

Posted on 2008-10-17
4
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 - Microsoft MVP, Access and Data Platform) 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

752 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