[AccessD] Matching Names & Qualifications

OK, I'm still not 100% clear but I'm guessing that the main form is
bound to your tbl_Evaluator and your AfterUpdate on the unbound combo
moves you to the right record. At that point Access sorts out the
subform through the Master and Child link. If this is the case then when
the form loads Access automatically goes to the first tbl_Evaluator
record in whatever sequence the form is bound to, and the subform will
display that evaluator's qualifications. What you could do to prevent
this is put some code in the OnOpen of the main form which goes to a
non-existent record and then requery the subform. If you're using
Autonumbers for the EvaluatorID (of course you are) then go to record
with an id of -1.

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



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> Hollis,Virginia
> Sent: 15 March 2003 16:51
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] Matching Names & Qualifications
> 
> 
> Note: Changed Engineer to Evaluator.
> 
> 
> Master & Child of the subform linked on EvaluatorID
> 
> Subform:
> SELECT tbl_EvalQual.EvalQualID, tbl_EvalQual.QualID, 
> tbl_EvalQual.EvaluatorID, tbl_EvalQual.DateQual FROM tbl_Qual 
> INNER JOIN tbl_EvalQual ON tbl_Qual.QualID = 
> tbl_EvalQual.QualID ORDER BY tbl_Qual.Qual;
> 
> Main Form:
> tbl_Evaluator
> 
> Combo for the Evaluator on Main form:
> SELECT DISTINCTROW tbl_Evaluator.EvaluatorID, [FirstName] & " 
> " & [Lastname] AS Evaluator FROM tbl_Evaluator ORDER BY 
> [FirstName] & " " & [Lastname];
> 
> I also did the same thing as above on another form to select 
> the Qualifications and list the Evaluators that match the 
> selected qualification.
> 
> 
> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk]
> Sent: Saturday, March 15, 2003 10:35 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Matching Names & Qualifications
> 
> 
> Virginia
> How have you done the subform? Are you using Master and Child 
> linking? If so is the main form bound to the Engineers table? 
> Or is the subform bound to a query which has a criteria that 
> looks at the combo on the main form? If you can describe how 
> you've done it I/we can help more easily. 
> 
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> 
> > -----Original Message-----
> > From: accessd-admin at databaseadvisors.com
> > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> > Hollis,Virginia
> > Sent: 15 March 2003 15:01
> > To: 'accessd at databaseadvisors.com'
> > Subject: RE: [AccessD] Matching Names & Qualifications
> > 
> > 
> > Never mind, I got the form working.
> > 
> > Just one last question.
> > 
> > I have an unbound combo box that lists the Engineers, then
> > afterUpdate it shows the qualifications for the selected Engineer.
> > 
> > Question: When the form opens the Engineer combobox is blank
> > but the qualifications subform lists the qualifications. 
> > Should the form & subform open blank? How can I have the form 
> > open to a blank record? Or at least the first engineer & 
> > their qualifications.
> > 
> > Virginia
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> > 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>