Need help with running a query from form using combo

[supermaestro]

Hello

I've created a form called 'General Mailshots'. This form consists of a combo box called 'Transaction Types' and a datasheet query called 'generalMailshotQuery'. What i'd like to do is for the datasheet view to refresh/re-run using the user defined criteria in the combo box. A)How do I get the form to re-run the query when the user clicks the combo box and B)How do I set the criteria in the query to match that that the user puts in the combo box?

I've tried everything and any help would be appreciated

 

[WildHare]

1) in the query, set the criteria for the field that matches the bound column of the combo box to

=Forms![General Mailshots]![Transaction Types]


2) in the After UPDATE event of the COMBO BOX, issue a requery of the datasheet control

Forms![General Mailshots]! { control name here }.FORM.REQUERY

I'm assuming that your datasheet is a subform? It's not clear.

If the datasheet is in the main form, just issue

Forms![General Mailshot].Requery

Get it?

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm