Search results for query: *

Ok basically this is what I want to know. How do I take the result of a query and put it in a text box. So if my query is this. "SELECT * FROM FooTable WHERE ID = '2'" How do I capture that result and put it into a text box to display to the user?

That only gives me the selected Item number, I need the query to be done with that number, as stated in my other post. When I put that code in After Update, it just puts a number in the textbox.

I'm new to Access and learning as I go. I have a text box that I am loading with data from a table once a combo box selection is made. I want the text box to be filled with the result of a query. However my code puts the exact string of the query into the text box. [Description] =...

Its ok, my lack of VBA knowledge means I probably screwed something up while playing around with settings.

Well I ended up just calling DoCmd.OpenForm right before I call it with the query passed to it. Seems to work ok and there is no visible difffernce to the user. So while its a dirty solution, I'm semi-happy with it. I may come back to it later. But to answer your questions. Does...

There is no open event. Below is the code for the form. Perhaps I can create an open procedure to grab run the line of code from my main form. Basically grabbing the ID from the list, since it is still running in the background. Option Compare Database Private Sub Form_Close()...

I forgot this.... Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmTestCase" stLinkCriteria = "[TestCaseID] = " & "'" & Me![lstMR] & "'" DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria

I am using the following code (on a list double click) to open a form and the first time the form launches it comes up blank. While the form is open, if I double click the item in the list again (which is on a form in the background) all the data is loaded ok. All clicks following the 2nd are...