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