Refresh subform

's Computer Specifications

Hi,

I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
button on the main form and it deletes every record in a table
(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
information (I can pause the code and see the updated records) but the
subform shows '#DELETED' for each field in each record.

I can close the main form and reopen it however I want to do more work in
the code but want the sub form to display the correct output.

I've tried Requery, Me.Requery etc but to no avail.

Thanks in advance.

--
Andrew

's Computer Specifications

Andrew wrote:
>I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
>button on the main form and it deletes every record in a table
>(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
>information (I can pause the code and see the updated records) but the
>subform shows '#DELETED' for each field in each record.
>
>I can close the main form and reopen it however I want to do more work in
>the code but want the sub form to display the correct output.
>
>I've tried Requery, Me.Requery etc but to no avail.

The syntax to requery a subform from code in the main form
is:

Me.subformcontrolname.Form.Requery

--
Marsh
MVP [MS Access]

's Computer Specifications

Hi Martin,

That (as you probably know) worked!!! Thanks for your help.
--
Andrew

"Marshall Barton" wrote:

> Andrew wrote:
> >I have a main form (Frm_Main) and a subform (Frm_Filenames). I click a
> >button on the main form and it deletes every record in a table
> >(Tbl_Filenames). The code then updates the Tbl_Filenames with updated file
> >information (I can pause the code and see the updated records) but the
> >subform shows '#DELETED' for each field in each record.
> >
> >I can close the main form and reopen it however I want to do more work in
> >the code but want the sub form to display the correct output.
> >
> >I've tried Requery, Me.Requery etc but to no avail.
>
>
> The syntax to requery a subform from code in the main form
> is:
>
> Me.subformcontrolname.Form.Requery
>
> --
> Marsh
> MVP [MS Access]
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update (refresh) Subform#1 when a check box is selected on Subform	GLT	Microsoft Access Forms	8	28th Jan 2010 12:41 PM
Subform within Subform on Main Form data refresh	=?Utf-8?B?Q0xN?=	Microsoft Access Form Coding	5	21st Mar 2005 11:07 PM
Urgent !!! - Values from Subform - #Error if no records in Subform and Only grabs first subform record	Greg	Microsoft Access Forms	0	17th Feb 2005 02:12 PM
Refresh one subform from another subform	Dkline	Microsoft Access VBA Modules	3	11th Jan 2005 07:15 PM
refresh refresh refresh refresh	JP	Microsoft Powerpoint	1	15th Aug 2003 04:44 AM