Search results

  1. M

    Showing ALL RELATIVE FIELDS in sub form

    Im really sorry Im not catching on, As of now, I have the code [Forms]![Form1]![txtmopat] in my SQL. "Form1" is in regards to the search form and my subform is called "Query1 subform" so what I did was I tried replacing "Form1" with "Query1 subform" and nothing came up. Am I typing this...
  2. M

    Showing ALL RELATIVE FIELDS in sub form

    I really appreciate the links guys, Thanks a lot! Bob, When you say "You also have to use .FORM. in between that control and any property, method, or control on the subform since Access needs to know if you are wanting something from the subform control or the subform." where do I enter that...
  3. M

    Showing ALL RELATIVE FIELDS in sub form

    Thanks for the link! I have this code within Query1 that allows for the "like" function to work. Its only when I put the sub form in that the "like" function didn't seem to work. SELECT Expertise.ID, Expertise.FirstName, Expertise.Expertise1 FROM Expertise WHERE (((Expertise.Expertise1)...
  4. M

    Showing ALL RELATIVE FIELDS in sub form

    If there are two categories in a query, "people search capabilities" & "technical People" and the user enters half of the phrase into the search box, "people", Is there anyway that both of the categories appear in the subform? As of now when i search "people" both categories show up in the...
    • mopat
    • Thread
    • Replies: 24
    • Forum: Forms
  5. M

    Showing the results in the same form

    Thanks James, It seems to be working. If there are two categories in the query, "people search capabilities" & "technical People" and the user enters half of the phrase, "people", Is there anyway that both of the categories appear in the subform? As of now when i search "people" both...
  6. M

    Showing the results in the same form

    Thanks for the reply! As of now, the search text box contains no code. It is only linked to the query. As for the Search button, that code is: Private Sub Command2_Click() On Error GoTo Err_Command2_Click Dim stDocName As String stDocName = "Query1" DoCmd.OpenQuery stDocName...
  7. M

    Showing the results in the same form

    Really Need help! I am still new to MS Access 07 and was wondering if someone can help me with this task. I have a FORM 1-->linked to QUERY 1-->linked to Expertise:TABLE. As of now, when I search for an item in the search box, the results are shown in a separate form. My goal is to have the...
    • mopat
    • Thread
    • Replies: 9
    • Forum: Forms
View older results
Back
Top Bottom