Ok, please bare with me as this may be difficult to explain.
I've created my forms and placed several forms as subforms, and then placed these forms on Navigation Form (I need the tab effects). My problem is that I've been trying to code a command button that is located on a subform that is stored on the Navigation Form. I've done so much re-coding that i can only provide the latest.
Forms and hierarchy:
formNameList ------\
formNameCard------\ -------(These forms become subforms of)---formContactCard---(This becomes a subform of the Navigation Form)---formMain
So above is the layout of the forms and how they are placed as subforms. So now for the problem: I have a command button on the formNameCard to open a separate form called "formEditComments" and filter based on ID(the Primary Key), which I have had working on the form itself. Now when I open the formMain where all work will happen, this button does not work, it asks for the Perimeter Value of "formNameCard". I need to pass the value held in the subform when opening the new form, but I believe I'm several forms deep and having trouble getting there. Since I am currently working in Macros (Not by choice), this is the Where Condition that I currently have:
[tblComments]![Contact ID]=[Forms]![formMain].[Controls]![NavigationSubform].[Form].[Controls]![txtContactID]
(What I have done is I added an unbound text box to the "formContactCard" which inherits it's value from the subform; in an effort to shortcut to the value needed to carry to the new form)
This is where i was at before:
[tblComments]![Contact ID]=[Forms]![formMain].[Controls]![NavigationSubform].[Form].[Controls]![formNameCard].[Form]
(Here I was trying to get down to the textbox which holds the ID for the contact, but unfortunately the system stopped giving me options to go any further.)
FYI - I am not using any "Link Master Fields" or "Link Child Fields" due to the fact that my subforms "formNameList" and "formNameCard" stop passing values back and forth and I can no longer show my continuous list of contacts and select each one as I want. So i don't know if this is having some effect here, but i need to do this without this feature, or so i believe.
Thanks in advance!