one query from two forms

[יריב החביב]

hello,

I have query that gives data according

to the date on a form, so i write " [forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or [forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i have to
clik on

in order to continue.

is there any better choice ?

thank you

 

[Rick B]

Not sure, but "month" is a reserved word. I'd recommend changing the name
of my control on both forms to use something other than a reserved word.
None of your controls or fields should be named reserved words such as:
"date", "null", "day", "false", etc. See the built-in help files for a more
complete list.

You say that you get some kind of "error form". If you would share with us
what is on that error, perhaps we could provide you with a more concise
solution.

 

[יריב החביב]

thank you rick,

I changed the name, but that not the case.

The 'error form' that I get is:

ENTER PARAMETER VALUE
forms!Tqkoopot_bakara!mont (blanc text box)

thanks
--
תודה רבה

Not sure, but "month" is a reserved word. I'd recommend changing the name
of my control on both forms to use something other than a reserved word.
None of your controls or fields should be named reserved words such as:
"date", "null", "day", "false", etc. See the built-in help files for a more
complete list.

You say that you get some kind of "error form". If you would share with us
what is on that error, perhaps we could provide you with a more concise
solution.

--
Rick B

hello,

I have query that gives data according

to the date on a form, so i write " [forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or [forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i have to
clik on

in order to continue.

is there any better choice ?

thank you

 

[Douglas J. Steele]

That means that Access wasn't able to find a control named mont on form
Tqkoopot_bakara.

Either you've mistyped something, or Tqkoopot_bakara isn't open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

thank you rick,

I changed the name, but that not the case.

The 'error form' that I get is:

ENTER PARAMETER VALUE
forms!Tqkoopot_bakara!mont (blanc text box)

thanks
--
???? ???

Not sure, but "month" is a reserved word. I'd recommend changing the
name
of my control on both forms to use something other than a reserved word.
None of your controls or fields should be named reserved words such as:
"date", "null", "day", "false", etc. See the built-in help files for a
more
complete list.

You say that you get some kind of "error form". If you would share with
us
what is on that error, perhaps we could provide you with a more concise
solution.

--
Rick B

hello,

I have query that gives data according

to the date on a form, so i write "
[forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from
another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or [forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i have
to
clik on

in order to continue.

is there any better choice ?

thank you

 

[יריב החביב]

yes, that is the problem

i want to use one query to read from two forms, one of them, at atime, is
close.

thanks
--
תודה רבה

That means that Access wasn't able to find a control named mont on form
Tqkoopot_bakara.

Either you've mistyped something, or Tqkoopot_bakara isn't open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

thank you rick,

I changed the name, but that not the case.

The 'error form' that I get is:

ENTER PARAMETER VALUE
forms!Tqkoopot_bakara!mont (blanc text box)

thanks
--
???? ???

Not sure, but "month" is a reserved word. I'd recommend changing the
name
of my control on both forms to use something other than a reserved word.
None of your controls or fields should be named reserved words such as:
"date", "null", "day", "false", etc. See the built-in help files for a
more
complete list.

You say that you get some kind of "error form". If you would share with
us
what is on that error, perhaps we could provide you with a more concise
solution.

--
Rick B



hello,

I have query that gives data according

to the date on a form, so i write "
[forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from
another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or [forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i have
to
clik on

in order to continue.

is there any better choice ?

thank you

 

[Douglas J. Steele]

You can't do it. The form must be open in order to refer to it in a query.

You're going to have to have 2 separate queries, determine in code which
form is open, and call the appropriate query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

yes, that is the problem

i want to use one query to read from two forms, one of them, at atime, is
close.

thanks
--
???? ???

That means that Access wasn't able to find a control named mont on form
Tqkoopot_bakara.

Either you've mistyped something, or Tqkoopot_bakara isn't open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

thank you rick,

I changed the name, but that not the case.

The 'error form' that I get is:

ENTER PARAMETER VALUE
forms!Tqkoopot_bakara!mont (blanc text box)

thanks
--
???? ???


:

Not sure, but "month" is a reserved word. I'd recommend changing the
name
of my control on both forms to use something other than a reserved
word.
None of your controls or fields should be named reserved words such
as:
"date", "null", "day", "false", etc. See the built-in help files for
a
more
complete list.

You say that you get some kind of "error form". If you would share
with
us
what is on that error, perhaps we could provide you with a more
concise
solution.

--
Rick B



hello,

I have query that gives data according

to the date on a form, so i write "
[forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from
another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or
[forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i
have
to
clik on

in order to continue.

is there any better choice ?

thank you

 

[יריב החביב]

that's what i wanted to know

thank you very much !
--
תודה רבה

You can't do it. The form must be open in order to refer to it in a query.

You're going to have to have 2 separate queries, determine in code which
form is open, and call the appropriate query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

yes, that is the problem

i want to use one query to read from two forms, one of them, at atime, is
close.

thanks
--
???? ???

That means that Access wasn't able to find a control named mont on form
Tqkoopot_bakara.

Either you've mistyped something, or Tqkoopot_bakara isn't open.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


thank you rick,

I changed the name, but that not the case.

The 'error form' that I get is:

ENTER PARAMETER VALUE
forms!Tqkoopot_bakara!mont (blanc text box)

thanks
--
???? ???


:

Not sure, but "month" is a reserved word. I'd recommend changing the
name
of my control on both forms to use something other than a reserved
word.
None of your controls or fields should be named reserved words such
as:
"date", "null", "day", "false", etc. See the built-in help files for
a
more
complete list.

You say that you get some kind of "error form". If you would share
with
us
what is on that error, perhaps we could provide you with a more
concise
solution.

--
Rick B



hello,

I have query that gives data according

to the date on a form, so i write "
[forms]![Tqkoopot_bakara]![month]".

In order to save space, i want to use the same query to reed from
another
form.

if i write

"[forms]![Tqkoopot_bakara]![month] Or
[forms]![Tsikoom_hodshi][month]"

it give me what i want, but after some kind of 'error form' that i
have
to
clik on

in order to continue.

is there any better choice ?

thank you