SEESAW Form?

[daryll]

Hi!


How do you call this type of form? Can anyone redirect me to a specific forum.


Pls see attachment.


Thanks
Daryll

 

[June7]

That's just a form with two listboxes. Selections from first listbox are 'transferred' to second listbox. SEESAW as good a name as any since I've never heard of any other name applied. Review https://www.tek-tips.com/faqs.cfm?fid=6326

 

[vba_php]

That's just a form with two listboxes. Selections from first listbox are 'transferred' to second listbox. SEESAW as good a name as any since I've never heard of any other name applied. Review https://www.tek-tips.com/faqs.cfm?fid=6326

June,

That is totally unnecessary I think. Why would you need class module code in Access to transfer selections from one listbox to another one?

daryll,

do you have ur own Access form that has 2 listboxes on it in which you want to do the same thing that happens with a seesaw form you see when you open a "create combo box wizard" in access? if that's what you want, the code is very simple.

 

[daryll]

daryll,

do you have ur own Access form that has 2 listboxes on it in which you want to do the same thing that happens with a seesaw form you see when you open a "create combo box wizard" in access? if that's what you want, the code is very simple.

Well, I hope I'm good as you. If you don't mind to lend me a link, i'll be grateful.


Thanks

 

[vba_php]

Well, I hope I'm good as you. If you don't mind to lend me a link, i'll be grateful.

I'm not *that* good, but if I understand you correctly, what you want *is* simple. see attachment.

 

[daryll]

That's just a form with two listboxes. Selections from first listbox are 'transferred' to second listbox. SEESAW as good a name as any since I've never heard of any other name applied. Review https://www.tek-tips.com/faqs.cfm?fid=6326

Ohh, I see thank you!

 

[June7]

@vba_php, well, it was first tutorial I saw in my search and it was by MajP so it seemed promising. I agree, far more complicated than necessary. Thanks for stepping in.

 

[vba_php]

Thanks for stepping in.

I don't know if *stepping in* is the right phrase. uve prolly got a lot more valuable advice than I do! by the way, the name is Adam, not vba_php.

 

[Gasman]

@vba_php, well, it was first tutorial I saw in my search and it was by MajP so it seemed promising. I agree, far more complicated than necessary. Thanks for stepping in.

@June7
That link shows two options. One with a class and one with just a form.
If I was creating such forms, I think I'd go with the class?.
All the hard work has been done for you, and you need about 5 lines of code in any form.?

Who cares if it is a class?, it is a black box routine, that I would gladly use, if I ever needed this functionality.

Thanks for the link.

 

[MajP]

A Rolex is real complicated but you do not need to understand how it works to use it to tell time. If you think rewriting code every time is easier have at it. I just instantiate a class with a line of code

 

[MajP]

When I build a class it may seem more complicated than could be done by simple hard wired brute force method. But I rarely write any code for a single use case. I write reusable encapsulated code. Write once use anywhere. Here is an example of a pretty good fake of "see saw" (from to) user control. This now functions almost like a true user control where you can drop the subform on any form and you can have all of this functionality, and never have to actually edit the subform or write code. Here is is used in 4 different ways, but the reuse is unlimited.

You can argue that it is buggy, or you do not like the features, or it is hard to initialize, etc. But saying the code is complicated is just stupid, and shows a lack of understanding of code development and code use.

 

[Gasman]

Well that is another benefit. You amend the code in the class and it is available everywhere.

I know a function will do pretty much the same thing, but still.