[AccessD] Basic Form Questions

Hi Jamie

Just after you do something that needs to show the refreshed data.
Say...in the After Update of the LastName field in Sub1 or something like that.

or say...as the last line of any relevant event procedure in sub1 

Have funn

Darrn


----- Original Message ----- 
From: "Jamie Kriegel" <jamie at kriegelpcsolutions.com>
To: <accessd at databaseadvisors.com>
Sent: Saturday, May 31, 2003 1:59 AM
Subject: RE: [AccessD] Basic Form Questions


> >>>>after your code on MySubForm1 does what  you want...
> Forms!MyHostForm!MySubForm2.form.refresh
> 
> Where do I put this code on SubForm 1?
> 
> Thanks,
> Jamie
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
> Sent: Friday, May 30, 2003 9:40 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Basic Form Questions
> 
> 
> Jamie
> RE Q1...small example db sent offline
> RE Q2...Just  like Charles said start refreshing your second sub
> Something like
> Assume sub 2 is called MySubForm2
> sub 1 is called MySubForm1
> Parent Form is called MyHostForm
> eg...
> after your code on MySubForm1 does what  you want...
> Forms!MyHostForm!MySubForm2.form.refresh
> 
> 
> Darren
> 
> 
> ----- Original Message -----
> From: "Jamie Kriegel" <jamie at kriegelpcsolutions.com>
> To: <accessd at databaseadvisors.com>
> Sent: Friday, May 30, 2003 12:50 PM
> Subject: [AccessD] Basic Form Questions
> 
> 
> > Hi there,
> >
> > I have 2 questions and I was hoping one of you generous and intelligent
> > people could help me.
> >
> > 1.  In a form I have a combo box that I use to as a lookup.  For example,
> my
> > form holds customer information and I use the combo box to choose a
> > paticular customer.  When I choose this customer, it is his/her
> information
> > that I see in the form.  How do I get this combo to default to a blank?
> > Right now it shows the name of my previous search in the on screen control
> > which can be confusing.  I want it to remain blank until I choose a
> customer
> > from the list.
> >
> > 2.   I have a form with 2 subforms.  The main form is customer
> information,
> > subform 1 is insurance policies that customer holds, and subform 2 is any
> > dependents that customer may have on a particular policy.  When I add a
> new
> > policy for a customer (subform 1), I have to go to a different record and
> > back before Access will allow me to enter data on subform 2 (dependents on
> > that policy).
> >
> > Any ideas would be wonderful!  Thank you,
> >
> > Jamie
> >
> > _______________________________________________
> > 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.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com