By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

if statements??

P: n/a
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.

Feb 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Feb 22 '07 #2

P: n/a
On 22 Feb, 20:34, "storrboy" <storr...@sympatico.cawrote:
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.
THANKYOU SO MUCH
XXXX

Feb 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.