Listbox not updating

[manpaul]

I have a simple screen.

A listbox, some fields, and a few command buttons, what is not working is when I click on a add button. In the add button I append a record to the table then refresh the field on the form if I refresh the listbox or refresh form the record pointer gets changed and the data from the first record is then displayed in the fields. All I want to do is refresh the listbox with the data as in is entered in the corresponding fields on the form. The listbox has 3 display fields.

Thanks Paul

 

[DSummZZZ]

Values loaded into the list box become static. After updating the table, you need to reload the items in the list box either manually using ADDLISTITEM(), or using Requery().


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[manpaul]

Tried the requery in the add command it shows the added record but moves the record pointer in the top of the table and when you go to change the data it is changing the data in the first record not the append or inserted record

 

[DSummZZZ]

Have you tried saving the record pointer and returning to the correct record after the requery?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[manpaul]

Thanks Dave I did that and it work ok but the highlite record after that was still the first record in the list, I found another solution (read all listbox questions in this forum) that seems to work well which was to place thisform.refresh in the valid method of the listbox and this has corrected my problem.

Thanks all Paul