Shifting Values between two forms

  • Thread starter Thread starter Imran Ghani
  • Start date Start date
I

Imran Ghani

Hi! I am making my application in MS Access with VBA coding. I want to have
two datasheet forms, one populated with the original set of values and the
other one empty. In between, there may be two command buttons; one to
add the values from left to right form and the other one that will do the
reverse. When one value is added from left form to the right one, then
that value should be deleted from the left one and vice versa. I'd much
appreciate your kind guidance.
 
This sounds like a typical dual list box selector you see in wizards and such
(with the arrow buttons in between). Is there any particular reason you
would like to use datasheet subforms for this rather than a pair of
listboxes? Listboxes can generally be manipulated easier than an entire
form, and I believe there are a number of published examples on how to
accomplish the task liek so.


hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
Thanks for your guidance. Can you please refer me some address where I may be
able to find such an example or if you could quote some such a kiind of
example, I'd be thankful.
 
Back
Top