Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
update query
- Thread starter Frank72
- Start date
- Thread starter
- #3
hows it going
none, it just seems to stop during run time, status bar stops moving. have used msgbox to see if jhko![jhg] works and the msgbox comes up with just what i typed in for prompt instead of value for some reason its not picking up the text box value
thanks
none, it just seems to stop during run time, status bar stops moving. have used msgbox to see if jhko![jhg] works and the msgbox comes up with just what i typed in for prompt instead of value for some reason its not picking up the text box value
thanks
If you designed your query with the qbe grid, go back to design view and change your query type to a select query - Then see if you get any records. Note that your form will need to be open to get the textbox value, or else you will be prompted for a parameter.
To be sure you are actually referencing a form, use the expression builder to select the textbox on the appropriate form.
Format wise, =[forms]![formname]![txtboxname] should be fine.
To be sure you are actually referencing a form, use the expression builder to select the textbox on the appropriate form.
Format wise, =[forms]![formname]![txtboxname] should be fine.
- Status
Similar threads
