Recent content by blankbandit

The database is full of proprietary, highly confidential data, so, unfortunately, I'd be unable to do that. Apologies. The setup is done just like the post suggested. I have a form, and, within the detail section, I have two unbound text boxes and then a list box. In the Search For text box, I...

Hello - John Big Booty posted an awesome thread in these forums. I'm unable to post a link due to not having posted at least 10 posts, but you can find the link by tacking on the following to this site's primary URL: forums/showthread.php?t=188663 It was, essentially, a type-and-show-as-you-go...

Thanks for all of the assistance. It's not working though. I don't know what the problem is. It's just not requerying. That's fine. The main thing that I wanted is working. Thanks again! David

Okay, bear with me. This is what I got and it's just not working... Private Sub Sold__Click() forms!Order_Form!Child18!Child64.requery End Sub I guess Access named my subforms as child18 & child64 when I created them. "Order_Form" is my main form. "Child18" is my Orders subform."Child64" is...

Thanks for your continued assistance... The "Sold" checkbox field is in a subform, Inventory. I like your idea of putting the requery in the "sold" check box to requery the query. The query is called CalculationsTotal and I put it into a subform, Calculations_Total_Form. So, this requery needs...

Thanks to both of you. It worked; however, when I do enter a new record, the query goes blank and just displays the field name. I believe this is what you guys meant by doing a "requery". Now, at this point, where do I add that "Me.Requery" extension so that it requery's the fields each time...

I need some help. My brain just can't grasp how to do this. I have an Access DB. I sell vinyl records. I have an order form. When a customer orders a record, each vinyl record has a unique ID#. No two vinyl records are alike. I have four tables: Customers, Orders, Inventory, & Order Details. I...

Hello everyone, Problem: I have an MS Access database in Frontpage that I'm using for my online site. Table is set up w/ a field named, "Artist" (amongst others). In this field I have artist's last name followed by a comma, a space, then the artist's first name. I am using the CONTAINS operator...