By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Filtering continuous Forms

P: 18
Hello,

I have a few questions. But first I'll give a little bit of info about my database. I'm creating a issue tracker, in a sense. It will be used to enter calls from customers for upgrades, bugs, reports, ect. There is a main form for information to be entered into the database. Then there is also a search and edit form, so if you need to enter addtional information for a specific product, you would search a continuous form and edit it. I have never done a database in my life, I was given this project to help out a department in my company.

My first question is:

I have a form, with a continuous subform (the search and edit form) in it to display all the current issues. I want to be able to sort that subform, first by client, than by status. How would I do this?

Next, there needs to be an option to "Add additional comments" associated with each record, that will automatically save when information is entered into there add. comments field. This needs to be a pop up box though.

I appreciate anyones help and thank you in advanced.
Sep 15 '08 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,494
Ordering of data in a form, any form, can be done either by providing a sorted query as the Record Source, or by setting the Order By property of the form itself.
Sep 15 '08 #2

NeoPa
Expert Mod 15k+
P: 31,494
For your second question (generally better to post separate questions in separate threads for future reference), it's not very clear how your "Comments" are stored.

In general, you can put some VBA code behind a Command Button which will open a new form if you like. For more specific help the question will need to be more specific I'm afraid.
Sep 15 '08 #3

P: 18
For the first question regarding the sorting the cont form. I want to have a drop down that will show the products, followed by a drop down that will have the status. Once those are selected, the continuous form will populate the appropriate records.

With regards to the second question, I would need to additional comments to be stored back into the main issue table
Sep 15 '08 #4

NeoPa
Expert Mod 15k+
P: 31,494
For the first question regarding the sorting the cont form. I want to have a drop down that will show the products, followed by a drop down that will have the status. Once those are selected, the continuous form will populate the appropriate records.
...
I don't see any connection to the first question (which has been answered fully as far as I can see).
...
With regards to the second question, I would need to additional comments to be stored back into the main issue table
This explains nothing. If anything it makes what you're after less clear. It's not even a sentence.

PS. If you can't get your questions to make sense then how can you expect a response.
Sep 15 '08 #5

P: 18
With regards to the Continuous form....

I have a form with a continuous subform in it. I want to be able to filter the subform. For example, say a customer calls and wants to check the progress on an issue. I want to be able to filter my continuous form first by the customer, than by the status (active). This should then only display the records for that customer that are active.


With regards to the additional comments...

Within the continuous form, I would like to have an "Additional Comments" button. When this button is clicked I need a pop up form so they can enter additional information. Once they enter the additional information, it needs to be saved on the issues table (with all the other information), the only problem I am having is the fact that each issues can have many additional comments. How would I do this so that it can save multiple "Additional comments" per issue
Sep 16 '08 #6

NeoPa
Expert Mod 15k+
P: 31,494
With regards to the Continuous form....

I have a form with a continuous subform in it. I want to be able to filter the subform. For example, say a customer calls and wants to check the progress on an issue. I want to be able to filter my continuous form first by the customer, than by the status (active). This should then only display the records for that customer that are active.
Well, to filter a subform, set the Filter property of the form within the subform control. How this is executed depends on when you know what you want, and the link between the main form and the subform.

In this case I suspect you want to set the .Filter property within the code directly. Have a look at Referring to Items on a Sub-Form to see how to reference this property from the code of the main form.
Sep 16 '08 #7

NeoPa
Expert Mod 15k+
P: 31,494
With regards to the additional comments...

Within the continuous form, I would like to have an "Additional Comments" button. When this button is clicked I need a pop up form so they can enter additional information. Once they enter the additional information, it needs to be saved on the issues table (with all the other information), the only problem I am having is the fact that each issues can have many additional comments. How would I do this so that it can save multiple "Additional comments" per issue
It really makes little sense asking this question without first explaining how the data is stored. What is the data structure in your database?
Sep 16 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.