[AccessD] Basic Form Questions

Jamie Kriegel jamie at kriegelpcsolutions.com
Fri May 30 10:59:37 CDT 2003


>>>>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



More information about the AccessD mailing list