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!
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...
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...
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...
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...
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...
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...
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
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...
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...