[AccessD] Go to a new record on a subform on a tab control

Susan, not sure if this is what you're asking but you refer to a subform on
a tab control just the same as any other. So the syntax is something like
(if you're on main form):

Me!subformControl.Form. Etc

Where subformControl refers to the name of the control containing the
subform not the name of the subform itself (if you see what I mean). So, for
example:

Me!subformControl.Form.AllowAdditions=True

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan
> Sent: 21 October 2004 20:53
> To: 'AccessD at databaseadvisors.com'
> Subject: [AccessD] Go to a new record on a subform on a tab control
> 
> 
> I have a main form (frmAllData) that contains a tab control.  
> So far there are two tabs on the control - Peopleform and frmCallData.
> 
> PeopleForm and frmAllData are both bound to the same table 
> (People).  I have a combo box (cboFindPeople) on frmAllData 
> that looks for someone on PeopleForm.  
> 
> Then frmCallData contains all the calls associated with the 
> person found.
> 
> If a person's name is input into cboFindPeople and that 
> person is not in the database, I want a yes/no message box to 
> pop up and if the user decides to add the person, I want to 
> set peopleform on the tab control to add and then I want to 
> populate the FName, LName, and ContactPerson controls with 
> the information in cboFindPeople.
> 
>  
> 
> I think I can populate the controls if I can just get to the 
> subform on the tab control and set the form to add.
> 
> Any help would be greatly appreciated.
> 
>  
> 
> Susan Klos
> 
> Senior Database Analyst
> 
> Evaluation and Reporting
> 
> Florida Department of Education
> 
> 850-245-0708 
> 
> sc 205-0708
> 
>  
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>