How to create a button which opens Form again and which starts parameters again?

[isladogs]

Adam
1. As already stated, the purpose of forums are so that a variety of members can offer suggestions and solutions. None of us know everything, nor do any of us always get it right.

FWIW, I think the solution proposed by moke was far better. Having said that, the important point is that Bambi has a choice of possible approaches and can/should make that choice for herself

2. You should not be speaking on behalf of other forum members. Whether or not you are correct in this case, Bambi is I'm sure perfectly capable of stating her own opinions and should be allowed to do so herself.

3. You should not be sharing (or even alluding to) the contents of PMs in a public forum

4. Also FYI, the site traffic at AWF is far greater than any other specialist Access forum and is almost double that of the next biggest (Utter Access). See https://www.similarweb.com/
Whilst far less than some Excel forums or more general forums like Stackoverflow, that reflects the comparative size of the user base for Access

AWF has been fairly consistent both in terms of audience and 'market share' for many years. AWF is certainly not perfect but its obviously doing a lot that's seen to be successful. Otherwise its site traffic would be in long term decline which isn't the case

 

[vba_php]

understood Colin. nice post. as you can probably see, I'm not like most of you guys in the effectiveness of solutions. most of my work is pretty much "garbage collection". and what that results in is a lot of successfully completed work and money earned, but a lot of risk assessment documents as well.

but the thing that has been my goal for a while now is helping people feel good about themselves by giving them whatever they need to help them along in their understanding of all this technological crap being introduced to the world. to me, none of it makes any sense and is totally useless (access users one of the many exceptions).

moreover, a lot of people listen to what i've got to say because i educate them about what they don't know. this has been evident in many interviews I've been in lately with hiring managers too. they inevitably say to me: "right?". I don't know how that all started, but every person I know in business does it, regardless of the power they have in the organization. I assume it started when that stupid "disrupt" economic model was adopted out in silicon valley as a "cover up" for those who thought something like "how did all this start? it's not my fault." so they created a fancy name for a new type of "economy" instead of admitting to the public the truth: "we can't employ you anymore cuz the machines are doing the work. sorry! fend for yourself".

if a person in an organization who has the most power has to ask some 2 bit nobody like ME if they are correct in their thinking, why would I work for them!? If they don't have any confidence about what they're doing or their strategy in business, they'll be out of business pretty quick!

 

[moke123]

adam,
I apoligize if you think I was stepping on your toes but this is an open forum and very often there are differring opinions on how to get the job done. I always try and be diplomatic in my postings and never criticize anyone in public for their knowledge or lack thereof. In this instance my concern was that Bambi was following you down the wrong path. Admittedly her original post alluded to using 2 forms but as you have stated she is new to development and unaware of the many options available to her. We have all worn those shoes. Just because someone asks for something doesn't mean we should just throw a solution back at them without trying to guide them in a more established direction. Look at how often posters are using non-normalized data and we stop them in their tracks and we send them back to the drawing board. We can easily give them a work around but what good does that really do for them.
In my opinion using 2 identical forms is just the wrong way to go. If you disagree I'm all ears.

@BambiKiss - Our apologies for this distraction and we welcome your continued involvement with AWF.

 

[vba_php]

Moke

I dont really care 2 bits bout ppl disagreeing with me. I get plenty of attention and work due to my high level of knowledge and how to get things to work. I dont disagree w u in the slightest. The point is to make other ppl feel good and prevent them from feeling like theyre stupid and can never get this stuff. Most of the time my solutions work but a lot of the times they arent what u intelligent engineers would call "correct". In my world there is no "correct". Its just "it works or it doesnt". And business ppl dont have time to care bout the nuiances of theoretical correctness. They r busy selling. So thats the difference between u and me. And both ways work just fine. Mine works better for the ppl i just described and urs works better for developers and engineer that have formal training. So this is no ones fault. Just like its no ones fault for mankind allowing their obsession with perfection turn into the technological nightmare that runs the world now.

 

[moke123]

Adam,
I'm not about to get into a pi$$ing match with you and we'll just have to agree to disagree.

The point is to make other ppl feel good and prevent them from feeling like theyre stupid and can never get this stuff.

I think the point is to encourage them and help them to learn to do it right and to feel good in their accomplishments.

Most of the time my solutions work but a lot of the times they arent what u intelligent engineers would call "correct". In my world there is no "correct". Its just "it works or it doesnt"

While I'll agree that I'm intelligent, I am not an engineer nor do I have any formal training.

And business ppl dont have time to care bout the nuiances of theoretical correctness. They r busy selling. So thats the difference between u and me. And both ways work just fine. Mine works better for the ppl i just described and urs works better for developers and engineer that have formal training.

While my business often lies at the edge of theoretical correctness (many of the other VIPs know what I do but it is not for public disclosure) I would be hesitant to engage with the type you describe and I'm sure they would rather have a solution that is correct rather than "just works" Btw, I have one of my old motorcycles for sale and it just works. Interested?

That said, I suggest we return control of this thread back to Bambi.

 

[vba_php]

Its not a pi$$ing match dude. We both r good at what we do. I enjoy my stuff and im sure u enjoy urs. Im not trying to get the last word in im just replying to u cuz this whole thing is a huge misinterpretation of everybodys words that went way overboard. As far as bambi.....i doubt we will hear from her again after all this.

And by the way Colin....mark this post on ur calender as a rarity. Im writing this post from my phone!

 

[vba_php]

ok guys, bambi is back! he apparently did not get scared off by the bickering in this thread. and for those of you who thought what I did....bambi is a male, not a female. I felt kind of stupid when he told me that, considering I've been calling him "my dear" for a while now. and he never said anything about it....

 

[Pat Hartman]

I've been calling him "my dear" for a while now

That is a pretty condescending way to refer to someone you don't even know.

Anyway, I skimmed the thread so if I am repeating a suggestion that has already been made, please forgive me.

Personally, when I open a second form and leave the first one open, I open the second form as model so that it has to be closed before the first form reacquires the focus. That means that a second search will reopen the form and so the results will be as expected. However, if you don't open the second form as model, you can click back and forth between them. That means that when you try to run a new search, nothing changes on the second form. The solution is to close FormB if it is already open. That will allow FormB to show the new results.

 

[vba_php]

That is a pretty condescending way to refer to someone you don't even know.

he never complained. i'm not worried about it.

 

[Vassago]

He may not have complained, but we would expect a bit of professionalism on the forum. Sexism has no place here any more than unwarranted bickering in a help thread.

EDITTED FOR CLARIFICATION

I expect no more replies from anyone unless it's to help with the original problem from KissBambi. This part isn't only directed at one person. This is a help forum and the thread was originally about a very specific problem. To clarify, I'm saying get back on topic. You can continue your unrelated discussion on another thread if you wish. We don't need to blow up KissBambi's email with posts back and forth that have nothing to do with his original issue.

Thanks!

 

[KissBambi]

Problem has been solved. Thank you to everyone for the help.


Best reguards


KissBambi

 

[isladogs]

@KissBambi
It is standard forum etiquette that threads with answers should not be deleted.
I have therefore restored this thread as, although its now solved as far as you are concerned, it contained many answers some of which may be useful to others in the future.
I realise that parts of it were, at the very least unhelpful, but I don't want to go through making judgement calls about whether individual posts should be deleted
However, I will lock the thread to prevent any further exchanges.
If you wish to discuss this decision, please send me a PM