Search results

Thank you so much for your help. I noodled around and changed the forms so that I could open the form with the attached code that I orginally had the question on. Double click on the part family field in fMainProgram and fMainPartFamily opens. However, I'm not sure if I am approaching this...

Hi, I was wondering if anyone might have a solution to my problem? Thanks for your help. Sandy

I was wondering if anyone else might hava a solution to my problem? Any help would be most welcome. Sandy

Yes and many other variations I have also tried this using my forms and controls that I found in the help section. ******************** The next two examples show how you might refer to a control named NewData on a subform ctlSubForm contained in the form called OrderForm...

I tried that and get a dialog box requesting a parameter value for fPartFamily.PFID any other ideas? I keep trying different things but I am very limited in vba. Sandy

The code bugs out here - strLinkCriteria = "[PFID]=" & Me![PFID] DoCmd.OpenForm strDocName, , , strLinkCriteria What I don't understand is why the code will work when fPartFamily is not nested. When I put a stop in the code, this error message popped up ** Syntax error (missing operator)...

the 1st code is for fPartFamily not fProgram.

I apologize, I did not inclue the on current code for fPartFamily or the code for fAssembly or the module. Perhaps this will explain further. As I stated in the original post, the code works when fPartFamily is not nested in the fProgram form. code for fProgram Private Sub...

I am using code to pass the PFID umber to the assembly form, here is the code for the command button. Private Sub cmdOpenAsmForm_Click() On Error GoTo Err_cmdOpenAsmForm_Click Dim strDocName As String Dim strLinkCriteria As String strDocName = "fAssembly" strLinkCriteria =...

I am designing a database for our engineering group. In the database I have the following tables; tProgram, tPartFamily, tAssembly, tSubAssembly, tSub2Assembly, tComponent, tMaterial and tProcess. I have attached a relationship screenshot. Using search I have found a partial answer to my...

I have read this post with great enjoyment and am compelled to throw in m 2 cents. For electric guitar there is also Carlos Santana, blues what about Johnny Lang, good old classis music I can go on forever - Guess Who, Poco Harem, Steppenwolf, CCR...and on and on.... I have a hard time...