Shifting Values between two forms

[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.

 

[Jack Leach]

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)

 

[Imran Ghani]

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.

 

[Jack Leach]

The couple of useful links I have found for access (most are asp.net) traced
back to this:

http://www.tek-tips.com/faqs.cfm?fid=4246


I haven't tested it (or done much more than skim it actually), but it seems
to be pretty thorough.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)