Using a Form for a Dialog Box

[Guest]

I have several Queries that all ask for a Supervisor Name. I have created a
Form with only a Combo box on it that has a pull down of that information.
The form is called 'Supervisor Name Drop Down' and the combo box is called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't seem to
get it to work. Any idea as to the problem?

 

[Bill Mosca, MS Access MVP]

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around the
name.

 

[Guest]

Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the pull
down box.
Ideas?

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around the
name.

--
Bill Mosca, MS Access MVP

I have several Queries that all ask for a Supervisor Name. I have created
a
Form with only a Combo box on it that has a pull down of that information.
The form is called 'Supervisor Name Drop Down' and the combo box is called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't seem
to
get it to work. Any idea as to the problem?

 

[Douglas J. Steele]

Take a look under Tools | AutoCorrect. Do you have "Replace text as you
type" enabled? If so, try turning it off.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the pull
down box.
Ideas?

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around the
name.

--
Bill Mosca, MS Access MVP

I have several Queries that all ask for a Supervisor Name. I have
created
a
Form with only a Combo box on it that has a pull down of that
information.
The form is called 'Supervisor Name Drop Down' and the combo box is
called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't
seem
to
get it to work. Any idea as to the problem?

 

[Guest]

Hi Doug!

I reset the Autocorrect and it did not make any difference.

Take a look under Tools | AutoCorrect. Do you have "Replace text as you
type" enabled? If so, try turning it off.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the pull
down box.
Ideas?

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around the
name.

--
Bill Mosca, MS Access MVP


I have several Queries that all ask for a Supervisor Name. I have
created
a
Form with only a Combo box on it that has a pull down of that
information.
The form is called 'Supervisor Name Drop Down' and the combo box is
called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't
seem
to
get it to work. Any idea as to the problem?

 

[Douglas J. Steele]

And you retyped the name to make it [Forms]![Supervisor Name Drop
Down]![Super], as opposed to [Forms]![Supervisor Name Drop
Down]![Supervisor]?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Doug!

I reset the Autocorrect and it did not make any difference.

Take a look under Tools | AutoCorrect. Do you have "Replace text as you
type" enabled? If so, try turning it off.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the
pull
down box.
Ideas?

:

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around
the
name.

--
Bill Mosca, MS Access MVP


I have several Queries that all ask for a Supervisor Name. I have
created
a
Form with only a Combo box on it that has a pull down of that
information.
The form is called 'Supervisor Name Drop Down' and the combo box is
called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't
seem
to
get it to work. Any idea as to the problem?

 

[Guest]

I retyped Forms![Supervisor Name Drop Down]!Supervisor where the form is
named Supervisor Name Drop Down and the combo box is named Super. After I
click out of the column to execute the query, something puts the brackets
around the pieces I spoke of.
Ideas?

And you retyped the name to make it [Forms]![Supervisor Name Drop
Down]![Super], as opposed to [Forms]![Supervisor Name Drop
Down]![Supervisor]?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Doug!

I reset the Autocorrect and it did not make any difference.

Take a look under Tools | AutoCorrect. Do you have "Replace text as you
type" enabled? If so, try turning it off.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the
pull
down box.
Ideas?

:

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around
the
name.

--
Bill Mosca, MS Access MVP


I have several Queries that all ask for a Supervisor Name. I have
created
a
Form with only a Combo box on it that has a pull down of that
information.
The form is called 'Supervisor Name Drop Down' and the combo box is
called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but can't
seem
to
get it to work. Any idea as to the problem?

 

[Douglas J. Steele]

Sorry, no other ideas. I'm afraid I've never seen this before.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I retyped Forms![Supervisor Name Drop Down]!Supervisor where the form is
named Supervisor Name Drop Down and the combo box is named Super. After I
click out of the column to execute the query, something puts the brackets
around the pieces I spoke of.
Ideas?

And you retyped the name to make it [Forms]![Supervisor Name Drop
Down]![Super], as opposed to [Forms]![Supervisor Name Drop
Down]![Supervisor]?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Doug!

I reset the Autocorrect and it did not make any difference.

:

Take a look under Tools | AutoCorrect. Do you have "Replace text as
you
type" enabled? If so, try turning it off.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bill,

When I put it in the Query, Access changed it to
[Forms]![Supervisor Name Drop Down]![Supervisor]
and then it asked for a value to be assigned rather than display the
pull
down box.
Ideas?

:

Try:
Forms![Supervisor Name Drop Down]!Super

When you put spaces in names you have to put square brackets around
the
name.

--
Bill Mosca, MS Access MVP


I have several Queries that all ask for a Supervisor Name. I have
created
a
Form with only a Combo box on it that has a pull down of that
information.
The form is called 'Supervisor Name Drop Down' and the combo box
is
called
'Super'. When I replace the original parameter in the query with

Forms!Supervisor Name Drop Down!Super

I get a syntax error. I have tried several other versions but
can't
seem
to
get it to work. Any idea as to the problem?