On Feb 22, 3:12 pm, "wannabeateacher" <s...@downtothewoods.me.uk>
wrote:
When using a form can i
put in a VB statement
saying
e.g.
if field from table "special needs"=deaf then field from query
"teaching assistant" "expertise" = deaf,)
I need to generate differing data held in seperate queries in the form
dependent on what data is selected from the first field.
In a query or form control you would use an IIF statement, in an event
proceedure you would use IF. (Note one has an extra I).
As a field in a query design grid FieldAlias: =IIF([Special Needs].
[FieldName]="Deaf",[teaching assistant].[Expertise]="Deaf",Null)
In an event:
If ControlName="Deaf" then OtherControlName="Deaf"
Read about these functions and see what you need to do to make them
work for you.