Search results

Negative. Data aggregation security concerns. Sorry. On second thought, I could prepare a 'demo'. I just don't have time right now. Maybe tomorrow.

I should add that, the subform control is not visible until a button is clicked. Button code changes that property back to 'visible'.

The cleanest thing would be to reopen the main form and allow the user to move to the next task. I need that to happen anyway, after the user makes the required edit thru this form. Here are more screenshots if they help.

Thanks DBguy I tried this, and I think it wants to work, but my new issue is interfering with it. That issue being, when I enter the serial number into the "Enter Parameter" dialog box, it does not get passed to the form. The form opens blank, and your message box is invoked. Here is the code I...

Thanks Pat. Yes, the SourceObject property on the form is blank, and populated from the button click. This is what is coming around to bite me in the ass. If I cancel the dialog box, then the SourceObject does not get specified, and that leaves a large empty white box where the form would...

Clearly I need to be more clear..apologies. First, please know that all my forms are pop-up forms 1. The Main form consists of a column of buttons on the left, with a subform control on the right. (sfctl) 2. Each button tells sfctl what the SourceObject is. ( Me.sfctl.SourceObject="FormName" )...

Like 'If me.dirty'? I'll try it.. but, has the form actually opened at this point? The form's filter has executed and is asking for input, but is the form considered open at this point? Curious..

Hello Friends I have a button on my main form which triggers a subform. The subform prompts for a parameter value up-front before opening. My issue is.. if I decide not to enter a parameter value and choose 'cancel' from the 'Enter a Parameter Value' dialog box, I end up with an unsightly...

OH! I totally get it now! Thanks so much, MajP. I appreciate the lesson. This is exactly what I was hoping for, and helps in more ways than just what I'm doing here. I little more light is shining on the machinery now. Very much obliged, sir. Kind regards.

Oh Yes.. I have one of these. ( I know this as a 'Switchboard'.) It occured to me that if I can do what Im after with this post, I won't need a navigation page (switchboard). My forms are small, and toggling between them would be easier for the user. Thanks though! Much obliged.

Thank you MajP.. Im teaching myself VBA and this particular scenario is a new challenge for me. Hiding the forms was the only way I could construct this with my limited VBA skills. Regarding your recommendation- me.parent.subform2ControlName.sourceObject = "FormName" What would...

Thank you DBguy. I'm not certain what that is. I'll google it up.

My Friends.. I would like a form with a sidebar of buttons on the left, adjacent to a subform on the right. Each button is to open a different subform. Each subform must open in the exact same spot No doubt you have all seen this format a hundred times; buttons on the left, toggling a view on...