Forms with two synchorinized subforms

  • Thread starter Thread starter Beatrix J B
  • Start date Start date
B

Beatrix J B

Hi ... still doing my cabinet and drawer project ... been trying to put a
subform in another subform but takes too much time to format and resizing
screen is quite difficult... how can i make it in such a way that i window
showing cabinets for that user is synchronized with another window drawers
that would only show drawers only available for that cabinet.
 
Beatrix,
Most usually, the One side of the relationship (the windows) would be on the main form
(one window per record), and all the assocaited drawers (the Many) would be displayed in a
continuous subform on that form.
You could use an unbound combo box on that main form that lists all the available
windows in your table, and upon selecting any window, you would go to that record in the
recordset, and there... see the associated drawers.

OR...
I've never used your method, but you could also try just using a filter in the query
behind the drawer subform. I'm assuming you have something like a WindowID for each
window and for each drawer, that relates the drawers to the windows. And, say you have a
WindowSub and a DrawerSub on the form (use your own object names)
= Forms!frmWindowMain!frmWindowSub.Form!WindowID
Each time you place the cursor in a window record in the WindowSub, requery the
DrawerSub. It should then show those associated drawers.
 
Back
Top