[AccessD] Basic Form Questions

Thanks Darrn,

That's just what I was looking for!
Jamie

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Sunday, June 01, 2003 5:55 PM
To: accessd at databaseadvisors.com
Subject: Re: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com