REQUERY Problem?

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a main form with a listbox, when I click on the listbox it sends
the selection to a hidden form, this works fine. I also have another
popup form that isunbound with a listbox that shows the records from the
hidden form, this almost works fine, the problem is that the listbox on
the unbound form is always one record behind. if I click on "1" I won't
see this in the popup form until lets say I click on "2", which I won't
see until I add another record. If I close the popup form and reopen it
of course I see Everything. Any help appreciated.
Thanks
DS
 
Why are you sending data to a hidden form? It sounds like you are starting
with a listbox on a form, trying to move a copy of the selected listbox
information to another (hidden) form, then using a third (popup) form to
look at the list on the (hidden) form.

If you want to know what item in the listbox was selected, you can refer to:
Me!MyListBox
(your syntax will vary). If you have the Multi-select property of the
listbox set, you can pick more than one item.

How is it that your "hidden form" can hold more than one record? ("... shows
the records from the hidden form..."). Usually, you save records to a
table...
 
Jeff said:
Why are you sending data to a hidden form? It sounds like you are starting
with a listbox on a form, trying to move a copy of the selected listbox
information to another (hidden) form, then using a third (popup) form to
look at the list on the (hidden) form.

If you want to know what item in the listbox was selected, you can refer to:
Me!MyListBox
(your syntax will vary). If you have the Multi-select property of the
listbox set, you can pick more than one item.

How is it that your "hidden form" can hold more than one record? ("... shows
the records from the hidden form..."). Usually, you save records to a
table...
Click to expand...
Jeff thats right, all because I want the result to be in a Listbox on a
form that can be moved around on the page and made visible or invisible
as neccasary. If I use a continouse form that works but...unfortunately
it's all got to cumalate into or onto a listbox, hey! could I put the
listbox on the "hidden" form and hide all of the other records?
Thanks
DS
 
Back
Top