<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1555" name=GENERATOR>
<STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU vLink=purple link=blue bgColor=white>
<DIV><FONT face=Tahoma color=#000080 size=2>very impressive. i love
it.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=timmer@melbpc.org.au
href="mailto:timmer@melbpc.org.au">Timmer-Arends</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, March 02, 2007 4:49
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [filtered] Re: [Year 12 IT Apps]
Assessement cross checking</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hello Sharon</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If I understand you correctly you have a form
attached to a table and you want a combo box to be used to move to the
record containing whatever it is that is selected from the combo box
list?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If this is the case then all that attaching the
combo box to the field will do is fill in the field with what is selected from
the list.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>There are several ways to tackle this but the
most straightforward to:</FONT></DIV>
<DIV><FONT face=Arial size=2>1. make a query (based on the table) that has all
the fields the form requires plus the field that has to be
matched.</FONT></DIV>
<DIV><FONT face=Arial size=2>2. attach the form to the query not the table (if
you already have the form, just change its record source)</FONT></DIV>
<DIV><FONT face=Arial size=2>3. make another one field table that contains the
list you want to have appear in the drop down list.</FONT></DIV>
<DIV><FONT face=Arial size=2>(now for the hard bits)</FONT></DIV>
<DIV><FONT face=Arial size=2>4. make a combo box on the form that is not bound
to the query but has the small lookup table as its list source (the wizard
should do all this for you). It is best to put this combo box in the header of
the form (switched on in design view from the view menu I think)</FONT></DIV>
<DIV><FONT face=Arial size=2>5. in the combobox properties list, give the
combobox an obvious name, and then via the events tab in the change event
create code (not macro) that simply has: Me.requery</FONT></DIV>
<DIV><FONT face=Arial size=2>6. save the form and close</FONT></DIV>
<DIV><FONT face=Arial size=2>7. open the query in design view and click
in the criteria row in the field which is to be search.</FONT></DIV>
<DIV><FONT face=Arial size=2>8. right-click and you should see 'build' -
select this and use the bottom three boxes to find the combobox by name. Click
'value', then OK, then save the query.</FONT></DIV>
<DIV><FONT face=Arial size=2>9, if all is well, opening the form and then
selecting the required value from the list should take you to the required
record - assuming the record exists.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>whew!!!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>A sample attached - hope its
helpful.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Robert T-A</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=walshs@avemaria.vic.edu.au
href="mailto:walshs@avemaria.vic.edu.au">Sharon A. Walsh</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers'
Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, March 02, 2007 3:27
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Year 12 IT Apps]
Assessement cross checking</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hello to all you
access experts out there.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Can anyone help me
out please by telling me a way I can link all the data together in a
form.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">My problem is that
my students have created drop down boxes for their Customer ID numbers in
the form and when they click on a new number all the original data still
remains. However the sac Im using requires the information on the form to
tick over when you select a new ID. <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Does anyone have
any ideas?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">S.
Walsh<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Ave
Maria
<o:p></o:p></SPAN></FONT></P></DIV>_______________________________________________
<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au </A>-
FAQ, resources, subscribe, unsubscribe <BR>IT Applications Mailing List
kindly supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc
</BLOCKQUOTE>_______________________________________________ <BR><A
href="http://www.edulists.com.au">http://www.edulists.com.au </A>- FAQ,
resources, subscribe, unsubscribe <BR>IT Applications Mailing List kindly
supported by <BR><A
href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au </A>- Victorian
Curriculum and Assessment Authority and <BR><A
href="http://www.vitta.org.au">http://www.vitta.org.au </A>- VITTA Victorian
Information Technology Teachers Association Inc<BR>-- <BR>This message has
been scanned for viruses and <BR>dangerous content by <A
href="http://www.mailscanner.info/"></B><B>MailScanner</A>, and is
<BR>believed to be clean. </BLOCKQUOTE></BODY><br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</HTML>