question about filters and subforms

[capri]

I would like to create something similar to the SalesTotals form in the Solutions database.

In my case I have a table full of Activites identified by a field called UID.

Rather than select an employee as in the SalesTotals form I would like the user to be able to select a UID. I currently have approximately 600 UID's which is rather much for a dropdown box to handle. Is it possible to form ranges of say 50 UID's, then the user first selects a range, then the actual UID?

I would like the subforms to display various details about the selected UID. I have the first subform set up okay, but can't get the
SelectUID (was Salesperson) in the header to work. I originally exported the form from Northwinds to my database, and just tried changing the appropriate names. However I keep getting an error that highlights

Private Sub Form_Current()
[SelectUID] = Null

the original form read

Private Sub Form_Current()
[SelectSalesperson] = Null
End Sub

and I can't see where I am making an error.

Any suggestions would be appreciated. Thanks.

[This message has been edited by capri (edited 09-20-2001).]

 

[Rich@ITTC]

Hi Capri

I am probably stating the obvious, but you do have a combo box called SelectUID (not Combo38 or similar)?

HTH

Rich Gorvin

 

[capri]

Thank Rich,

yes I do have a combo box called SelectUID .
I think my problem may be where I am linking it from. Originally I was taking it from a query that combined 2 tables, in a one (UID) to many (TaskID) relationship. I just tried switching it over to the tblActivity and the top part now works fine, but the detail is not picking up the UID that I select in the Form Header.

I want to be able to select a UID, then have a subform showing all of the tasks (normally 3 or 4 but occassionally up to 10)related to it. In another subform I would like the actual description of the activity to appear, and in a third subform any dates related to the activity (DueDate, CompletedDate). There are a number of other subs I could add to provide even more detail about a given activity. Since this is my first time working with subforms I think I'll have to think through trying to understand where to draw the information from for each piece.