| re: Refresh Subform from Main Form
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" <bob_kaleel@yahoo.com> wrote in message
news:1102447671.269179.19730@z14g2000cwz.googlegro ups.com...[color=blue]
> 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
>[/color]
| 
