Search results

Thanks for the tip! :) I have this now... Private Sub Form_Load() Me.Parent.SF2Cont.LinkMasterFields = TempFID Me.Parent.SF2Cont.LinkChildFields = FID End Sub I am error free... however the form is not filtering at all... it opens with all records... help?

Post continued... maybe i would like to try putting this code in each subform "load" or "open" event? I have several subforms. Each load into the same control (SF2Cont) via an on click event in another adjacent subform. Some of the forms need to (child) link on a field named PID, and some on a...

I'm sorry, I guess I need to start from the first. Sorry to be such a slow learner... I appreciate your patience. I have a parent form with a textbox named "tempfid" in the form header. I have a subform control named "SF2Cont" which loads a form with a field named "fid". I have tried so many...

This is what I am experimenting with... I have a subform control named "SF2Cont" and a text box control named "TempFID" both on the same parent form. The subform that loads into the SF2Cont contains the field FID. Private Sub Tab2ButtonLabel_Click() Me.Parent.SF2Cont.SourceObject =...

Thank you again for your help, I found this reference... Syntax expression.LinkChildFields expression A variable that represents an ObjectFrame object. Is there a place I can see an example of how to create the actual line of code? I am new to VBA and much of it just doesn't make sense...

okay i will, thanks for the tip.

Thank you for the response, are you referring to the "help" button in access or is it a part of this website? I have been searching for days to try to find the answer, both in and out of access, and I must be doing something wrong...

Thanks for your input, I truly appreciate it. Actually this is a redesign I am attempting of an app that has been in use for about 2 years. The current system utilizes many tabbed forms with many subforms. We get the "cannot open any more databases" error and I was trying to overcome that by...

Good morning, is there a way to change the "link master" 'link child" properties of a subform control in VBA? This is what I am attempting- change the target of a subform control and define the link properties in one event (I am a VBA novice so I am not sure if "event" is the correct term.)...

Ok- here is the file. In a nutshell, this is what I hope to do. I have people with a unique id "PID" the people are in families, with an "FID" I have some forms that need to link on PID such as person info, address, etc. I have other forms that need to link on FID such as the example "AgencyFID"...

ok will do... it will take me just a bit.

Here is a picture of my form layout... maybe it will help?

Still experimenting- feel like a blind man bumbling around in the dark... I have place this code on my "parent" form, "MainNavigationForm". I placed a textbox control in the form header named "TempFID" that = the FID I am trying to filter on. Public Sub ChangeOutSubform2(sfmName As String) '...

Hello Lagbolt- So, trying to implement your code here... the two sfconts that contain the FID's are the header with the client's info "Nav_HeaderSFCont" and the subform that loads into SF2Cont. I tried various modifications of the line with the me.filter = FID and i keep getting the error that...

Thanks, my brother is a db guy but he refuses to do anything ms... so when i ask him questions he politely declines. I am trying to "graduate" from macros and wizzards to vba and im really trying to understand the language. is there a recommended reading you can point folks like me to that...

Thank you very much... i will try to digest and implement. VBA is still very mysterious... but I'm trying, and I really want to learn.

Hello and good day- I am making good progress on building my forms, but I have another question, and after trial and error and a few hours searching forums I am not able to figure it out on my own. This is what I need to do, I have the above code working perfectly, however, i need to include a...

Both of us? Me and the database? hehe. Have a very good new year!

Wow! I think I got it to work, even I amaze myself at times. Thanks to all who contributed, many times over. I am now able to switch tabs and tab "buttons" error free!

I will try to upload a copy of what I am working with...