[Year 12 IT Apps] Dropdown list in Access

[Litsa Tzelepis]

Hi Luke,
does your colleague want to add another staff member to the learning area?
For example, when he says, "on the LOTE form, all the LOTE teachers need to
be in the drop down", what is he then trying to do?
I'm intrigued and would like to help if i can.
Litsa




On Wed, Jun 19, 2013 at 3:24 PM, Luke Ellis <LEllis at loreto.vic.edu.au>wrote:

>  Hi all****
>
> Can anybody help solve a colleague’s problem? I’ve had a look and can’t
> see the problem, unfortunately my Access skills are a bit rusty as I am not
> teaching IT Apps this year.****
>
> ** **
>
> *From:* Rhys Alexander
> *Sent:* Wednesday, 19 June 2013 3:22 PM
> *To:* Luke Ellis
> *Subject:* Dropdown list in Access****
>
> ** **
>
> On a form, I have some fields (Teacher Code, Subject, Learning Area etc.).
> This form is based on a Staff table.****
>
> I would like to use the form to update the data in the Staff table. ****
>
> I want to use a drop down list to select and add an item into the staff
> table, based upon the current record shown in the form.****
>
> For example, if the record shows the Maths Learning Area, I only want
> Maths teachers in the dropdown list. When the record shows the LOTE
> Learning Area, I only want teachers of LOTE to appear in the drop down list.
> ****
>
> Whilst I have achieved this “manually”, it is neither efficient nor
> desirable.****
>
> How do I set up my form so that the dropdown list only shows the teachers
> for that Learning Area for that current record?****
>
> ** **
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>



-- 
Litsa Tzelepis
Mount St. Joseph Girl's College
133 Maidstone Street, Altona, VIC. 3018
htzelepis at msj.vic.edu.au
P:8398 2000 | F:9398 3498

This Email and any attachments may be confidential and, if you are not the
intended recipient, you must not disclose or use the information in this
email. If received in error, please notify the sender and Mount St. Joseph
Girls' College immediately and delete the Email and all copies. Mount St.
Joseph Girls' College does not guarantee that this email is virus or error
free. The attached files are provided and may only be used on the basis
that the user assumes all responsibility for any loss, damage or
consequence resulting directly or indirectly from the use of the attached
files, whether caused by the negligence of the sender or not. The content
and opinions in this Email are not necessarily those of Mount St. Joseph
Girls' College. Please consider the environment before printing this email.

-- 
 

IMPORTANT! This email and any attachments may be confidential. If received 
in error, please contact us and delete all copies. Mount St Joseph Girls' 
College does not represent or warrant that the attached files are free from 
computer viruses or other defects. The attached files are provided, and may 
only be used, on the basis that the user assumes all responsibility for any 
loss, damage or consequence resulting directly or indirectly from the use 
of the attached files, whether caused by the negligence of the sender or 
not. The liability of Mount St Joseph Girls' College is limited in any 
event to either the resupply of the attached files or the cost of having 
the attached files resupplied. Any representations or opinions expressed in 
this email are those of the individual sender, and not necessarily those of 
Mount St Joseph Girls' College.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130621/9b84358d/attachment.html