• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Clearing an unbound list box

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:
Frank Freese
Frank Freese
1 Solution
What is the rowsource of the listbox?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:

Me.YourListBoxName.RowSource = ""

Frank FreeseAuthor Commented:
Great! I tried that a few minutes ago and it work so you affirmed I did  the right thing
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

Me.lstBOM.Value = Null

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now