Displaying aggregate info about query in Text box

[June7]

If you don't want to provide a sanitized db by some means I can't figure out the issue. Something is seriously wrong with the form arrangement.

[SteveFlash]

Ok I am going to scrub it the best I can and I will post it up. This will take a while.

[SteveFlash]

I'm sorry it will not be possible thank you for the offer though. I would have to change nearly everything in the db to take out the private info which I started to do but of course everything because very unstable. This sucks. I am just going to have to waste a whole week trying to make one small little thing work. jesus. How can the subform be unbound but it displays the query and when I change the control criteria and requery it displays the correct data from query on the subform.

[June7]

If can't change a few pieces of info than something is wrong with db structure. Could try to copy relevent tables without data into a new file.

[SteveFlash]

I will try to get something up tonight.

I really appreciate your help though. Honestly I would have got fed up awhile ago. Thank you a ton.

[June7]

If this is not solved by tomorrow night, will be 2 weeks before I can deal with again.

[SteveFlash]

So while I have been working to clean this thing of private info I have been tinkering around with it I think I am misunderstanding something here. I deleted the Subform that was displaying the query (the one that is unbound somehow) and then place a brand new subform in its place completely blank. I then went to it's properties to assign it Master and Child fields through the 3 dot builder thing and it still says "Cant Build a Link Between Unbound forms". What is going on here?

I mean what does it mean to have a bound form and how the hell do you do it?

[June7]

A form/report is bound when it is associated with a data source. Set the form's RecordSource property. Can be a table or query object or an SQL statement.

A subform/subreport is constructed by placing a subform/subreport container control on a form/report then setting the SourceObject property. This can be a table, query, form, report.

Master/Child links are properties of the subform/subreport container control, not the object held by the container.

[SteveFlash]

HI. I wanted to let you know I was able to get it to work kinda. I just need to refresh the box with the aggregates for it to update along with the subform. Now my problem is the whole thing is really running slow now before it ran fast. How could something as simple as averaging a column make this thing move 5 times slower. I think I might upload it to the web and see how it reacts in that format.