Listbox stops displaying with runtime version

[Max Moor]

Hi All,

I have a 2002 app. One form has a listbox with a query tying it to
records to display. Also on the form is a button used to add a new record.
I use .AddNew, set a couple things, then .Update. Then I requery the
listbox.

Everything works fine if I open things on my development machine, in
Access. I then use the SageKey installer to make a distribution package.
When I run this on my test machines, the listbox doesn't show the added
records.

I've copied the backend off a test machine and have verified that the
new records are being added. In fact, on the form is a record counter, and
it increments every time I add a record. The list box just doesn't show
anything.

I can't understand why it would work under access, but not with
runtime. Has anyone seen such a thing before, and have any pointers to get
me started again?

Regards,
Max

 

[Gina Whipp]

Max,

Do the new records show up if you exit the form and go back to it?

Also, might help if you show us the code that you use to update/requery the
list box. There might be something there that would help.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm