DiscoDuane
MIS
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
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