Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Clearing an unbound list box

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
Frank Freese
Asked:
Frank Freese
1 Solution
 
peter57rCommented:
What is the rowsource of the listbox?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:


Me.YourListBoxName.RowSource = ""

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

Me.lstBOM.Value = Null

JimD.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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