displaying data according to a field

R

Rani

guys I am new to access
here is what I've created so far:
I have a query displaying a number of activities associated with a sales rep
I've created a form based on that query, I would like the info to be
displayed according to the sales rep name selected from a combobox (I
created the combobox so far)
what do I do next?
 
S

Steve Schapel

Rani,

Is it an unbound combobox (if I understand you correctly, it should be).

In the Criteria of the sales rep in the query, put the equivalent of this...
[Forms]![NameOfYourForm]![NameOfTheCombobox]

Then, on the After Update event of the combobox, you may need to put
code like this...
Me.Requery
(assuming the combobox is on the sales rep activities form).
 
Top