<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Hey Chris,<div><br></div><div>The from needs to be open and not in design mode or layout mode for the criteria or be picked up. If any one of these conditions is not met you’ll get a blank query </div><div><br></div><div>Regards</div><div>Brett G<br><br><div id="AppleMailSignature">Sent from my iPad</div><div><br>On 24 May 2018, at 7:01 pm, Peter Repse <<a href="mailto:PRepse@maranatha.vic.edu.au">PRepse@maranatha.vic.edu.au</a>> wrote:<br><br></div><blockquote type="cite"><div>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<p>Send through the database file and I reckon it will make it easier for us to help out.<br>
</p>
<p><br>
</p>
<div id="Signature">
<div style="font-family:Tahoma; font-size:13px">
<div class="BodyFragment"><font size="2" face="Tahoma">
<div class="PlainText">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="line-height:106%"><a name="_MailAutoSig" id="NoLP"><span style="font-size:10.0pt; line-height:106%; font-family:"Century Gothic",sans-serif; color:#003F87">Kind regards,<br>
<br>
<b>Peter Repse<br>
Secondary Teacher<br>
</b>Maranatha Christian School, Casey Campus Endeavour Hills<br>
104-108 Reema Blvd, Endeavour Hills, VIC 3802<br>
Direct: 9709 7285</span></a><br>
</p>
</div>
</font></div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> yr11it <<a href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a>> on behalf of Paragreen, Chris J <<a href="mailto:paragreen.chris.j@edumail.vic.gov.au">paragreen.chris.j@edumail.vic.gov.au</a>><br>
<b>Sent:</b> Thursday, 24 May 2018 5:35 PM<br>
<b>To:</b> Year 11 Information Technology Teachers' Mailing List<br>
<b>Subject:</b> [Yr11 Information Technology] Access Database Help</font>
<div> </div>
</div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hello everyone,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’m stumped on an issue in Access. I’ve created a simple database for a music library. I’m creating a report of songs that belong to a particular album. The album is selected using a combo box in a form, which
is populated by the entries in the “Albums” table. However, when I try to use the value of the combo as a filter for the report query, I always end up with an empty dataset. Can anyone shed any light on what might be missing/wrong?</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Regards,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Chris</span></p>
</div>
<table>
<tbody>
<tr>
<td bgcolor="#ffffff"><font color="#000000">
<pre>IMPORTANT - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.</pre>
</font></td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
The information in this email is confidential and may be privileged or subject to copyright. It is intended for the exclusive use of the addressee(s). If you are not an addressee, please do not copy, distribute or otherwise act on the email. If you have received
the email in error, please contact the sender immediately and delete the email. The unauthorised use of this email may result in liability for breach of confidentiality, privilege or copyright.<br>
Whilst we have used appropriate software to alert us to the presence of computer viruses, we cannot guarantee that this email or any files transmitted with it are free from viruses.<br>
<br>
Maranatha Christian School<br>
</font>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe</span><br><span>Year 11 It Mailing List kindly supported by</span><br><span><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html</a> - Victorian Curriculum and Assessment Authority</span><br><span><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc</span><br><span><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</span></div></blockquote></div></body></html>
<table><tr><td bgcolor=#ffffff><font color=#000000><pre>IMPORTANT - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Training.</pre></font></td></tr></table>