Refresh Subform from Main Form

[New2Access]

Hi,

I have a form thats used to enter records into a table. The table and
form have fields for Name, week, project, and hours. To assist users,
I wish to add a subform that will show them how many hours and for
which projects they've already made entries.

To do this, I created a query based on the same table with criteria
pointing to the current user, and the week selected in the main form.
This seems to work fine except the subform only shows data when the
user makes an entry in the main form.

IOW, the subform is blank when first opened, although the main form
defaults to the current user and current week. Once the user starts to
enter a project in the 'project combobox' the subform shows data. Once
the new record is added however, the subform is once again blank. Once
the user goes to enter another project, the subform will show data
(including the last record) but goes blank once that record is entered.
Is there anyway to have the subform show data all the time? Thanks

[HS Hartkamp]

Is the subform linked to the record in any way (master-child property) ? If
so, I don't think it should be.
I think this might be solved using the method me.sfrmProjectHours.Requery

Good luck,

Bas Hartkamp.
"New2Access" <bo********@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

Hi,

I have a form thats used to enter records into a table. The table and
form have fields for Name, week, project, and hours. To assist users,
I wish to add a subform that will show them how many hours and for
which projects they've already made entries.

To do this, I created a query based on the same table with criteria
pointing to the current user, and the week selected in the main form.
This seems to work fine except the subform only shows data when the
user makes an entry in the main form.

IOW, the subform is blank when first opened, although the main form
defaults to the current user and current week. Once the user starts to
enter a project in the 'project combobox' the subform shows data. Once
the new record is added however, the subform is once again blank. Once
the user goes to enter another project, the subform will show data
(including the last record) but goes blank once that record is entered.
Is there anyway to have the subform show data all the time? Thanks