Apr 24 2012, 07:07 PM
I have a main form with a Claims sub-form which shows various claim reasons via a drop-down list showing several controls (fields?) - there is usually more than one reason for a claim.
I can make a query based on one of the drop-down claim reasons but how can I display the other reasons so that I can see all the reasons particular to that record?
Example: Looking at the main form Record 6 displays basic information while the sub-form displays several reasons for a claim.
I am particularly interested in a particular or main reason (rent arrears) and want to see all records with this reason. This I can do via a query and have set up a form to display this, but how can I also display the other reasons applicable to record 6 at the same time?
I think it will be quite a complicated piece of code but I have absolutely no idea how to go about this.
Apr 24 2012, 07:16 PM
your main table relationship with the other tables will play a big part to display what you are interested to see as a result of a query.
it will help it you can upload a copy of your db.
Apr 24 2012, 08:33 PM
Thanks ReyObrero, here is the zip file. I had to make a copy of the file and delete lots of things but i think it is working. And yes, I know, it is not a very elegant database but it does mostly what I want; I just keep finding other things I want to do, as in this instance.
The two important forms are "Main Form" based on the Main Table and "Claims query Form" based on the Query "Claims query"
The way I find a reason for the claim is that on the "Claims query Form", I sort the control/field ClaimReason in alphabetical order and then move to the first record that has the reason I want. However, I would like to be able to see the other claim reasons for each particular record; just as I can see them on the Main Form (where they can be seen on the subform). One problem is that one the main form, I cannot sort anything in a subform.