I volunteered to do a small Access project for a friend based on my
experience writing an appln. with Access many years ago. It has been
a struggle to re-learn information about applying Access.

Here are some of the problems that are stumping me:

1. A form with a subform displays the data for the form's datasource
correctly but the subform data does not display at all. I've messed
around using the Requery method for the form and the subform. Nothing
I've tried works all the time. (Me.Requery appears to work on one
version of the form right now but it doesn't work a alightly different
version of the same form.

2. When I try to "Save As" for a Form used as Subform, Access exits
with an error dialog. I have 23 forms, 9 queries and 4 tables.
Database size just before the crash was ~2.1 Mbytes.

3. All sorts of things seem to happen strangely if I've left other
forms open in design mode when I run the form with the subform.

I'm using Access 2002 on a laptop with 512 MB running XP Home and the
database is in Access 2000 format. (That is what my friend has.)

Any ideas for solutions would be appreciated.

Bill