Search results

Frankly, I for one still abide by my NDA. I suspect so do the others. We can no longer participate in NDA discussions though.

I'm a member of an MVP forum that now has a lot of ex-MVP's. None of us can figure out how MS makes its decisions here. Albert is going to try and reapply in a few months.

That is indeed a useful discussion for this thread Jack. Thank you for posting. BTW, were you aware of the fact that Albert was NOT renewed as an MVP this month? I couldn't believe it.

Certainly a valid point but you have to admit that my solution did not suffer from that drawback. Your very helpful post are always filled with useful tips and I admire them a lot.

I'm sorry Colin, but I think you were a little harsh with your comment. I believe your opinion only applies to *your* solution but not to all solutions. It just struck me as very unlike your usual assistance.

Welcome...welcome...welcome. I'm sure you will be able to supply us with some very useful tips.

Thanks for the update! :)

Just pass information to the form in the OpenArgs argument. http://www.baldyweb.com/OpenArgs.htm

Sorry but my email post office is sick right now so I never got notifications of your post. Are you saying that the RecordSource of the SubForm is set by the ComboBox selection?

Where are you automatically populating these text boxes? In what event?

It looks okay to me. Have you disabled the errors?

Thanks Colin. Filed away for use later! :)

A great big WELCOME to ya! Glad to see you on board.

Welcome to the site. Sit back, relax and enjoy yourself!

No problem Dave. We all do it! :D

If you use the method both Dave and I suggested then you do not need to know what form opens the transactions form! It keeps your code more modular. :)

If you open the "transaction form" as Dialog then the code behind the button waits for the next form to close or become invisible. It would be right after the OpenForm command in the button where you would run your Me.Requery.

Keep us posted on the results, please. :)

In that case you can just use the Me.ControlName syntax and it should work for any MainForm. What sets the value in the ControlName? Is it the Record Source of this form? If so, there is absolutely NO problem.

Is the ListBox on the actual SubForm and is the Control you are referencing also on that same SubForm?