Recent content by goodhvnting

  1. G

    Keyword search box with results displayed in subform

    Hi again, I was able to solve the problem by following everyone's instructions. Thanks to you all who tried to help me out. I am so very grateful. Saved me a lot of time and energy. Thanks again!
  2. G

    Keyword search box with results displayed in subform

    Hi MarkK, I think I understand what you are doing here. I am still having a problem with this statement: Private Sub SetSubformRecordSource() ' here we set the recordsource of the form in the subform control (the subform) Me.tblRecords_subform.Form.RecordSource = "SELECT * FROM...
  3. G

    Keyword search box with results displayed in subform

    Hello! This is my 3rd time posting in this wonderful and supportive community. My first two questions have been solved and I am back hoping to build on what i've already learned. Problem: I have a main form with a subform that displays records. In the main form I have an unbound text box...
  4. G

    Help! Using checkboxes and search box to search multiple fields with subform

    Yes I do see what you are doing! That makes perfect sense... I knew I was missing code that points the recordsource to the subform but I had no idea how that code should be written. I feel like a broken record but thank you again for solving this for me. This community is the best. All the...
  5. G

    Help! Using checkboxes and search box to search multiple fields with subform

    Hi MarkK, Yes, your observations make sense and you are correct. I am trying to apply the record source to the subform. I can now see that my checkboxes don't work... it looked like it was working but after more tinkering I could see that it really is not. Any advice on how I can go about...
  6. G

    Help! Using checkboxes and search box to search multiple fields with subform

    Hi MarkK, Many thanks for taking the time to try to help me out. Again. I really appreciate it as I don't have other resources to turn to. I am not sure how to go about printing the SQL. I tried using the code you provided but nothing pop ups that allows me to print the SQL. However, there...
  7. G

    Help! Using checkboxes and search box to search multiple fields with subform

    Hello! This is my second post in this awesome community. My first question was solved and now I am back hoping to learn more. Problem: I created a continuous form that has check boxes and a search box. My check box filters out results based on what is selected, and my search box can search...
  8. G

    Help! Search using checkboxes and search box for multiple fields

    Nevermind! I figured it out! I had an extra bracket one of the property clauses. MarkK... again - so many thanks for responding and taking the time to show me exactly what I was doing wrong. Many thanks, I would not have been able to figure this out without your help and this community. :D
  9. G

    Help! Search using checkboxes and search box for multiple fields

    Thank you MarkK for taking the time to try to help me. I really appreciate it as I am a bit overwhelmed by all of this. I must admit that I have absolutely not programming experience and have been trying to create this database for my job using internet resources and youtube videos. Therefore...
  10. G

    Help! Search using checkboxes and search box for multiple fields

    Hello! This is my first post asking for help in this awesome community so please bare with me as I try to explain my problem. Problem: I am hoping someone can help me with part of my code. I have check boxes and a search box that both work. My checkbox filters out results based on what is...
Back
Top Bottom