Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refreshing a ListBox

Status
Not open for further replies.
Sep 22, 1999
76
US
I have a form that will add Material to a list box based on what was entered on the form when they click add. What i would like is the list box to refresh with the recently added data.
The problem is that the listbox will show data only after the 2nd Material is added And it shows both enteries
Details:
When user Clicks Add button it writes the data to a table
and refreshed the lstbox

I've used me.lstMat.requery and me.refresh
Both times the listbox only shows data after 2 entries

Listbox is unbound and the rowsource is set on FormLoad to
Select * from tblEstMatUsed where jonum = strJO

I've also put a stop on the Click Event for the cmd Button and check that the data is in the tblEstMatuSed before the refresh is called

Thanks for ur help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top