I am trying to create a text box that will populate (on click) the most recent value in a query. A small catch is that while the form is open, new data will be entered into the query so the query has to be refreshed (from what i've seen that should be "Requery") to get the newest data. Is there some type of code to be able to click this text box to refresh the query then populate the top value in that query?
I tried going around this by basing the text box value on a combo box value. Basically, on click, the text box would read the same value as the combo box. The default value for the combo box is the value I want to enter (top value in query). But due to the data being entered while the form is open the default value is no longer what I want. The form is being refreshed on a timer to refresh the query but, the default value doesn't become the top value in the query any longer. Is there a way to make the default value in the combo box refresh to populate the new top value while the form is open?