Ask Your Question

how to update Form's resultset using a macro [closed]

asked 2013-03-12 02:32:10 +0100

jvapr27 gravatar image

updated 2020-07-27 20:05:51 +0100

Alex Kemp gravatar image

Hi, I'm trying to execute a query and then update the table control on my base form. I believe I understand that the data for the table control is really coming from the base Form data resultset. Question is, how do I update the Forms resultset once I executed the query and have a resultset to iterate through?

anyone have any ideas?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-01 22:16:31.337840


example: I have a form with a table control. When the form loads, it will not display any values in the table control. I want to provide the data for the table control after a user enters some text in a field and hits 'search' button. Then I want grab the info from the user and query the db. I have made it this far, now how do I update the table control to display the data i get back from the resultset? Thanks.

jvapr27 gravatar imagejvapr27 ( 2013-03-15 02:18:37 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-08-10 19:24:47 +0100

Alex Thurgood gravatar image

Usually with


in your macro, which must call the reload on the main form or, if you have multiple subforms, on the control that you need to refresh. See here

edit flag offensive delete link more

answered 2013-03-14 01:30:34 +0100

qubit gravatar image

Hi @jvapr27,

Could you upload an example file for us to take a look at? That might help us better-understand your problem.


edit flag offensive delete link more

Question Tools


Asked: 2013-03-12 02:32:10 +0100

Seen: 3,033 times

Last updated: Aug 10 '14