[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