Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Using Macro to update Form resultset

Hi, I have experience in querying databases and iterating through their result sets, however I'm trying to execute a query and then update the table control on my 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?

Thanks

Using Macro to update Form Form's resultset

Hi, I have experience in querying databases and iterating through their result sets, however I'm trying to execute a query and then update the table control on my 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?

Thanks

click to hide/show revision 3
rephrased question in title

Using Macro how to update Form's resultsetresultset using a macro

Hi, I have experience in querying databases and iterating through their result sets, however I'm trying to execute a query and then update the table control on my 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?

Thanks

how to update Form's resultset using a macro

Hi, I have experience in querying databases and iterating through their result sets, however 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?

Thanks