Search results

Hello Lagbolt, and thank you so much for trying to help! Yes, the code to open a new instance of the form works great. The next thing that happens is I click on my left nav subform (contained in the SF control SF1Cont) to change the source of my other subform (SF2Cont) and I get the message...

Apparently I'm not allowed to paste the picture...

Dear Lagbolt and Chris, Here is the code: Option Compare Database Private Sub Tab1ButtonLabel_Click() Forms!MainNavigationForm!SF2Cont.SourceObject = Me.Tab1FormName End Sub What I have done is this... I have a main form named "MainNavigationForm" (I changed the name of the form since my...

Thanks, Lagbolt, is there not a workaround for this? Is there another way to reference the form(s)? I sure appreciate the help!

Hello, I discovered this post a few days ago and was able to follow the instructions at Allen's site... however... my main form has subforms. The subforms load into the subform control based on code for an onclick event. When I open an instance of the main form, the code to load the subforms no...

Hello- I am hoping someone out there can help me with another issue related to the first... I have all of the subforms loading properly based on the above code, however, when I try to enter data into any of the subforms my cursor starts flashing from an arrow to an hourglass, the subform seems...

Thank you Thank you! I got it to work beautifully. I changed the name of the field in my record source that contains my form names to "Tab1FormName" and then changed the code to this: Private Sub Tab1ButtonLabel_Click() Forms!NavigationForm!SF2Cont.SourceObject = Me.Tab1FormName End Sub Next...

Quick update- this did work after I removed the ".caption" from the end of the line of code. I will play with it a bit to see if I can still get it to work with my form name field instead of the caption but this is a great start. Thank you!!

Thank you JHB, but this doesn't seem to work. The labels have spaces between the words, i.e., "Person Info" and my forms do not, i.e., "Nav_PersonSF". I am not sure if that is the reason, but the code you gave me produces errors. Any other ideas?

Hello, I have tried to figure this out and I am just not getting it...:banghead: I am trying to create an "onclick" event for a control in a "navigation menu" style subform that will change the source object in another subform control on the same main form. (similar to the new "navigation form"...

Hello all, i am going in circles, again, I would appreciate any help I can get. I have a query with the fields Adult Last and Adult First from the "Adult Info" table. I have a form based on the query. I have been able to create lookups in the last and first fields to determine if the person...

OK- i really do appreciate your help. will do that next.

re the field names, yes i will take care of that... re "I would set it up so that the Child is the main form and then the other tables linked to it is its own subform on the main form. You can use a tab control for that",,, that is what i have been trying to do, and when i add about my 2nd or...

DESPERATE for HELP! Thanks to anyone who has a moment to try to help me- is there a way to make all the forms contained in a navigation form controlled by the same combo box record lookup????

please let me know if you need more info, i am SO GRATEFUL for the help!

the sample can be found at (trimmeragency.) (com/sample/ma_t.jpg) this forum says i can't post a link until i have at least 10 posts/// were you able to get that ok? :)

Could there possibly be a way to use a navigation form instead of tabs, but make each of the "nav" forms display the related records to the record displayed in the first of the nav forms, does that make sense? My goal is to not have to make the gals at the non profit have to look up the child...

Thank you so much for taking time to help- i have less than the max, and i keep starting from scratch, so i think i am ok there... is there anything you can think of that would work, I am DESPERATE for help. I am trying to create (what I thought would be a quick project) for a non-profit. just...

I have a question, if it's not to late, is it possible to have a form that has too many controls, or pages? I seem to keep hitting the same brick wall. When designing a form that I hope to have linked to about 15 tables, i get to a point where the form stops allowing data entry, (when i get so...