Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

clear listbox after add data to table

In this example i had help with-
is there anyway to have listbox cleared after command button clicked and data added to table.
if you close form and open back up - items still there
thank you
db11.mdb
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Well, you can do this:

Private Sub Form_Load()
    Me.List12.RowSource = ""
End Sub

But ... how would plan on putting it back ?

mx
In other words, when do you want the list items to appear?

mx
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davetough
davetough

ASKER

both solutions seem to be working- thank you