[AccessD] Refresh subform? SOLVED!

Sad Der accessd666 at yahoo.com
Wed Dec 20 01:59:51 CST 2006


Thnx Andy!
.Form. did the trick!

----- Original Message ----
From: Andy Lacey <andy at minstersystems.co.uk>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Wednesday, December 20, 2006 8:36:31 AM
Subject: Re: [AccessD] Refresh subform?


Sander
>From the main form try

Me!fsubVLAMStaging.Form.Requery

but fsubVLAMStaging MUST be the name of the subform control NOT the
subform's actual form name.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
> Sent: 20 December 2006 05:15
> To: Acces User Group
> Subject: [AccessD] Refresh subform?
> 
> 
> Hi Group,
> 
> I need to refresh a subform but I cannot get it to 
> work....duh. The form is very simpel. In the main form I've 
> got 2 buttons: 
> Import
> Delete
> 
> The button import imports data into a table tStaging
> The button delete deletes all data from the table tStaging.
> 
> The subform displays the records in tStaging.
> The subform is NOT linked to the main form (so not via an ID 
> field or anything else).
> 
> The forms name is fImport. 
> The subforms name is fsubVLAMStaging.
> 
> I've tried several things:
> in the subforms OnCurrent event [fsubVLAMStaging].Requery => 
> Nothing in the subforms OnCurrent event me.Requery => Nothing 
> in the form fImport in the OnClick event of the buttons 
> me.[fsubVLAMStaging].Requery?!?!
> 
> 
> Shouldn't be to hard I thought...
> Anybody got a clue?
> 
> TIA!
> Regards
> Sander
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databas
________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the AccessD mailing list