Query Result view in Form Text Field (1 Viewer)

[Bandara]

I was created a Query to Update A table Field Value. Icreated a form and add button to run the query. The query is only update the field value of a table. So How can i show inmy form next to query submit button Result of the query (After run the Query Updated Field Value) .

Please Help Me

Thank You

 

[Ranman256]

you run 2 queries,
1 the update qry,
2, the select query to show the results using the key in 1.

 

[isladogs]

Or you can use a DLookup function on that record in your table as your textbox record source

 

[theDBguy]

Hi. If you're saying the form is showing the old data, and you want it to show the new data, then you could try using the Requery method.