D
doodle
Greetings all.
windows xp, access 97
To make a long story short, I have an Order Entry form (frmOrderEntry)
and a datasheet subform that is a list of parts the customer is
ordering (sfrmCustParts). They are linked by RefNum (master and child).
On my "switchboard" (frmMainSwitchboard), I have a search option at the
top where the user can enter the order # in the text box and click the
"search" command button.
Their is a subform on the "Switchboard" (sbfDemoMain). When the user
clicks the search button, the control source for sbfDemoMain is changed
to frmOrderEntry.
The order entry form appears with the correct order number, all is well
except that the parts list shows ALL PARTS - not just the parts for
that RefNum. My link is not working and I can't figure out why.
The funny part is that if I compact the database and run the same
search, the form shows correctly (for a while, at least). I would think
that if I fubared it, it would not work even after the compact.
help
-doodle
windows xp, access 97
To make a long story short, I have an Order Entry form (frmOrderEntry)
and a datasheet subform that is a list of parts the customer is
ordering (sfrmCustParts). They are linked by RefNum (master and child).
On my "switchboard" (frmMainSwitchboard), I have a search option at the
top where the user can enter the order # in the text box and click the
"search" command button.
Their is a subform on the "Switchboard" (sbfDemoMain). When the user
clicks the search button, the control source for sbfDemoMain is changed
to frmOrderEntry.
The order entry form appears with the correct order number, all is well
except that the parts list shows ALL PARTS - not just the parts for
that RefNum. My link is not working and I can't figure out why.
The funny part is that if I compact the database and run the same
search, the form shows correctly (for a while, at least). I would think
that if I fubared it, it would not work even after the compact.
help
-doodle