Replies

I think it would be the database. It is being used by 1 user right now. It is going to be placed on a network drive so that 3 people can access it. It is just a regular Access 2000 database (tables, forms and reports).
Thanks Hans.

Thanks Hans – don’t know how to write code so will have to do with what I have.

I thought it would be easier for the person using the DB to have a button that they could click. I can do the toolbar but I’m still not sure how to get the filter on subform. When I try – it just filters the subform.
thanks
Robin

Yes, they are datasheet view.

I guess I didn’t explain this very well. I have a form that has a command button that the user can click on and activate the Filter by Form option. From the form the user can select anything on the main form and click apply filter and it filters for the main form and the 2 subforms. What I would like the user to be able to do is click the command button then be able to click into either of the 2 subforms make a selection or set criteria then click apply filter.
thank you in advance to all that can help

Thank you all for your help and suggestions. This is a wonderful form and everyone is so helpful.

How do I get the OrderAmount stored in my Order Details table.
Thanks

Rudi / Hans thanks for your responses. Yes, I have a table called company specialty, and a linked table called specialty. It is then linked to company. I have 209 specialty items that can be selected. The linking table holds company ID and Specialty ID along with Applicable (Yes/No). The company form is very complex with 2 other subforms on it. So I wanted users to be able to click a command button that would open up the 209 different specialties showing what had already been selected but allowing them to select or deselect from the list. The problem was that when I created the linked form some of the companies only have 13 or 14 specialties listed instead of the 209.
Thank you in advance. I am working all day tomorrow in case you get back to me and I don’t respond.

Rudi / Hans thanks for your responses. Yes, I have a table called company specialty, and a linked table called specialty. It is then linked to company. I have 209 specialty items that can be selected. The linking table holds company ID and Specialty ID along with Applicable (Yes/No). The company form is very complex with 2 other subforms on it. So I wanted users to be able to click a command button that would open up the 209 different specialties showing what had already been selected but allowing them to select or deselect from the list. The problem was that when I created the linked form some of the companies only have 13 or 14 specialties listed instead of the 209.
Thank you in advance. I am working all day tomorrow in case you get back to me and I don’t respond.

Thanks so much Hans – worked great.

Thanks so much Hans – worked great.

Hi Hans – Sorry I was out for the evening. Hope you still are following this.
I set up a command button with an On Click procedure as follows:

Private Sub Command38_Click()
On Error GoTo errhandler

Dim fil As Form
Dim stDocName As String

stDocName = “Alphabetical Contact List” ‘**The report you wish to preview**
Set fil = Forms![Frm_Company] ‘**The form you have added the button to**

If iFilterType = acApplyFilter Then
DoCmd.OpenReport stDocName, acPreview, , fil.Filter ‘**If a filter has been set on the form then apply it to the report**

Else
DoCmd.OpenReport stDocName, acPreview ‘**If there is no filter then just generate the normal report**
End If
errhandler:
End Sub

Hi Hans – Sorry I was out for the evening. Hope you still are following this.
I set up a command button with an On Click procedure as follows:

Private Sub Command38_Click()
On Error GoTo errhandler

Dim fil As Form
Dim stDocName As String

stDocName = “Alphabetical Contact List” ‘**The report you wish to preview**
Set fil = Forms![Frm_Company] ‘**The form you have added the button to**

If iFilterType = acApplyFilter Then
DoCmd.OpenReport stDocName, acPreview, , fil.Filter ‘**If a filter has been set on the form then apply it to the report**

Else
DoCmd.OpenReport stDocName, acPreview ‘**If there is no filter then just generate the normal report**
End If
errhandler:
End Sub

I have one form with 2 combo boxes that I can select the Company Type then select a company that belongs to that type. It displays the information for the Company on the main part of the form and in 1 subform, the offices that belong to that company and in another subform the contacts that belong to the office that you click on. I then created a filter button that will display a report . But first you have to click into the company name control on the form, then click the Filter by Selection button on the toolbar, then click my command button that previews the filtered information (Company, Offices and Contacts) of the filter by selection. When you close the report it returns to the form but then you have to click the remove filter button on the toolbar. I would like the command button I created to: Focus on the Company Name that is selected (move the forcus to it), do a Filter by Selection automatically and open the report; when you close the report to automatically remove the filter from the main Company form.

Hopefully I have explained it a little better. Thanks Hans

I have one form with 2 combo boxes that I can select the Company Type then select a company that belongs to that type. It displays the information for the Company on the main part of the form and in 1 subform, the offices that belong to that company and in another subform the contacts that belong to the office that you click on. I then created a filter button that will display a report . But first you have to click into the company name control on the form, then click the Filter by Selection button on the toolbar, then click my command button that previews the filtered information (Company, Offices and Contacts) of the filter by selection. When you close the report it returns to the form but then you have to click the remove filter button on the toolbar. I would like the command button I created to: Focus on the Company Name that is selected (move the forcus to it), do a Filter by Selection automatically and open the report; when you close the report to automatically remove the filter from the main Company form.

Hopefully I have explained it a little better. Thanks Hans