Pyrrhonist
Programmer
Having a problem getting my page to refresh the subforms the way I want them to The followink link will show the basic front end I'm working with
SSG File, Reserve, Ship Code and Project are all unbound text boxes. You can do a search, by entering your string into whichever text box you want, then querying with the 'binocular' search button. My query string builds fine, and the qryResults table populates fine too, BUT, what I WANT to happen, is real time updating within the Subforms which are placed on the table layout below the search. I have three subforms, which display different parts of the same row from the same table. The three subforms are linked to the same form that the main form is using as a control source. ANY suggestions would be GREATLY appreciated, as I've tried TONNES of different options, but to no avail
Tried using me.requery, Forms!frmName!subfrmName.requery, ummm...and a few others, but it wont requery One thing to note, is that I am NOT using a recordset to store the values in...not sure if that makes a difference or not, but the values are being calculated and placed into a new qry, which is the source for the subforms. Umm....this is getting long, so if you have any suggestions, or have any further questions you need, PLEASE get ahold of me Thanks in advance for any advice you can give
SSG File, Reserve, Ship Code and Project are all unbound text boxes. You can do a search, by entering your string into whichever text box you want, then querying with the 'binocular' search button. My query string builds fine, and the qryResults table populates fine too, BUT, what I WANT to happen, is real time updating within the Subforms which are placed on the table layout below the search. I have three subforms, which display different parts of the same row from the same table. The three subforms are linked to the same form that the main form is using as a control source. ANY suggestions would be GREATLY appreciated, as I've tried TONNES of different options, but to no avail
Tried using me.requery, Forms!frmName!subfrmName.requery, ummm...and a few others, but it wont requery One thing to note, is that I am NOT using a recordset to store the values in...not sure if that makes a difference or not, but the values are being calculated and placed into a new qry, which is the source for the subforms. Umm....this is getting long, so if you have any suggestions, or have any further questions you need, PLEASE get ahold of me Thanks in advance for any advice you can give
