Using a Form for a Dialog Box


G

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?
 
Ad

Advertisements

B

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.
 
G

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?

Bill Mosca said:
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


Bunky said:
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?
 
D

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!)


Bunky said:
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?

Bill Mosca said:
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


Bunky said:
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?
 
G

Guest

Hi Doug!

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

Douglas J. Steele said:
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!)


Bunky said:
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?

Bill Mosca said:
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?
 
D

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!)


Bunky said:
Hi Doug!

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

Douglas J. Steele said:
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!)


Bunky said:
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?
 
Ad

Advertisements

G

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?

Douglas J. Steele said:
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!)


Bunky said:
Hi Doug!

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

Douglas J. Steele said:
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?
 
Ad

Advertisements

D

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!)


Bunky said:
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?

Douglas J. Steele said:
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!)


Bunky said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top