2 subforms, one updating another.. resources?

[flynbye]

OK'z... I have the feeling that I'm asking another dumb question but I've created a tabbed form that list all of my customers proposal line items and change order line items in two subforms on one of the tabbed pages. The first subform seems to be working fine and the second forms data is built using a query selecting data based on information in the recordset of the first subform. My problem is that I can't seem to get the second subform to display the query results unless I manually select it and perform a sort or some other filtering which I assume triggers a requery. Once I trigger the display by manually selecting a sort the data results seem to be exactly what I need.

Can anyone point to a resource on multiple subform linking or suggest code to requery / repaint the data into the second subform?

Thanks!

 

[flynbye]

OK'z... an evening tinkering and got that to work so solved this one on my own. Still I'm having an issue now that perhaps someone has some input on. When I rearrange the columns in the second subfile window the columns revert back to their original positions, sizes etc. Anyone have any idea why they would be doing that?

The subform is built on a tabbed sheet and everything else seems to be working fine.

Here is hoping someone has a solution.

 

[montrose]

Is the subform actually a tabular frm or a datasheet frm? You should be able to rearrange the columns in design view on a tabular frm and save the changes, or in datasheet view move the columns around and save those changes. If the subfrom is actually bringing up the qry and not an actual frm, I don't think it will save the changes. You'd have to make the qry into a tabular or datasheet view frm to be able to keep the layout changes. HTH. Montrose Learn what you can and share what you know.