T
Tom Mackay
I am trying to create a form which :
(i) allows user to input criterion to select client records by various fields
(ii) display the records meeting the criterion in a sub-form on the form
(iii) ultimately, allow user to de-select/delete individual records from the
select results before delivering each an email
First I tried to launch a make-table query via a button and let the sub-form
query those results. But whenever the button was pressed, it could not
complete...record locking, I guess, against the sub-form which has that table
"open".
Then I tried to launch a simple query, and let the sub-form query those
results. When the button was pressed, the query successfully ran but two
problems...one, the query itself actually came up on-screen and two, the
sub-form did not refresh.
I have fiddled with refresh and requery commands but cannot get them to
work. So, any help would be apreciated.
Txs,
Tom
(i) allows user to input criterion to select client records by various fields
(ii) display the records meeting the criterion in a sub-form on the form
(iii) ultimately, allow user to de-select/delete individual records from the
select results before delivering each an email
First I tried to launch a make-table query via a button and let the sub-form
query those results. But whenever the button was pressed, it could not
complete...record locking, I guess, against the sub-form which has that table
"open".
Then I tried to launch a simple query, and let the sub-form query those
results. When the button was pressed, the query successfully ran but two
problems...one, the query itself actually came up on-screen and two, the
sub-form did not refresh.
I have fiddled with refresh and requery commands but cannot get them to
work. So, any help would be apreciated.
Txs,
Tom