Troubles with a subform in a form with 2007

  • Thread starter spcscooter via AccessMonster.com
  • Start date
S

spcscooter via AccessMonster.com

This may be a little tricky for me to explain but here it goes.

I have an Access 2003 DB that works great but when it is used in 2007 one of
the forms I have which has a field for employee name list box and once the
desired employee is selected their entire list of tools is supposed to be
shown, but comes up blank. There is also a report button that will display a
completed report which is created from the same objects the subform is
created from. It is almost like the Employee Name field is not being seen by
the subform. If anyone can help with this I would really apreciate it. If
you need any other information please let me know.

Thank you,
 
A

Allen Browne

Open the form in design view, and make sure the new FilterOnLoad property is
set to No. Do that for the subform as well.

If that doesn't solve the problem, there might be a timing issue. Try
requerying the form (F9.)

If you are still stuck, let us know how the filtering of the subform works.
Does it use the subform control's LinkMasterFields property? Or criteria in
a query? Or ...
 
Top