refresh textbox form from subform during click event

[thread]

Hi all,
I'm trying to build a code that will change textbox control during a
click,
for now without a success,i know there is a command called refresh or
requery but from some reason its just working after the click event
has already finished,
is it posible to refresh the textbox during the click event?

 

[SusanV]

Use the On Mouse Down event rather than On Click

 

[thread]

i dont see any results in the change,is it accuring doing the on
click?
mouse down seems to be one function before the on click without any
refresh form on the way
can you comment on this?

SusanV כתב:

 

[SusanV]

What exactly are you trying to do?

i dont see any results in the change,is it accuring doing the on
click?
mouse down seems to be one function before the on click without any
refresh form on the way
can you comment on this?

SusanV ???:

 

[thread]

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV כתב:

 

[SusanV]

Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:

 

[thread]

[form]![control].controlsource = "=1"

SusanV כתב:

 

[SusanV]

What else is happening - is there more code than that in your event? Are you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:

 

[SusanV]

What is the "-1"? Is that a table or query name? If it's a value that you
want to se in the textbox, try using:
Me.ControlName = "=1"

[form]![control].controlsource = "=1"

SusanV ???:

 

[thread]

hi
the on click is buliding a table and populating it to excel
its very important that the textboxes will be correct otherwise it
will have wrong filters

SusanV כתב:

What else is happening - is there more code than that in your event? Are you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:

Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:

 

[SusanV]

So... you need this change prior to building the table? I'm sorry, but it's
very difficult to help you when you are so reluctant to explain what is
happening, getting the info in bits and pieces, it's like pulling teeth...


hi
the on click is buliding a table and populating it to excel
its very important that the textboxes will be correct otherwise it
will have wrong filters

SusanV ???:

What else is happening - is there more code than that in your event? Are
you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:

Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:

 

[thread]

i'm sorry for this,i just fill that it not good to go around,so i
prefer to go stight to the point,i assume is not good as well in those
cases,
i have 4 textboxes
cycle1,cycle2
this year,previous year
thats its
both are used to be a criteria in a query
sometimes i will need them to appear for example
cycle1 will show 1
cycle2 will show 2
CrtYear will show 2007
LstYear will show 2006
and sometimes i would like it to give this criteria for the query
cycle1 will show 1
cycle2 will show 1
CrtYear will show 2006
LstYear will show 2006
so the only time i''m making those changes is while clicking the
button,i do not give any the user any option to make any changes to
the criteria beside some logic that i have for the specific questioner
that i'm building
i hope its spreading more light on the issue
SusanV כתב:

So... you need this change prior to building the table? I'm sorry, but it's
very difficult to help you when you are so reluctant to explain what is
happening, getting the info in bits and pieces, it's like pulling teeth...


hi
the on click is buliding a table and populating it to excel
its very important that the textboxes will be correct otherwise it
will have wrong filters

SusanV ???:

What else is happening - is there more code than that in your event? Are
you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:

Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:
What exactly are you trying to do?

i dont see any results in the change,is it accuring doing the on
click?
mouse down seems to be one function before the on click without any
refresh form on the way
can you comment on this?

SusanV ???:
Use the On Mouse Down event rather than On Click
--
hth,
SusanV

Hi all,
I'm trying to build a code that will change textbox control during
a
click,
for now without a success,i know there is a command called refresh
or
requery but from some reason its just working after the click
event
has already finished,
is it posible to refresh the textbox during the click event?

 

[SusanV]

No problem, glad to help - just simpler when I know what's happening on your
end <smile>

Not certain I understand your table structure though - if you have the
option of "This Year" or "Previous Year" in one field (control) why do you
need it in an additional field/control? It would be simpler to use a single
control, rather than trying to force the update of what appears to be a
duplication in function... Also what happens in 2008? Do we add another
field "2YrsAgo" to the table and shuffle the data so that 2YrsAgo holds what
is now in LastYear , and LastYear holds what is now in CrtYear, 2CrtYear
becomes empty?




i'm sorry for this,i just fill that it not good to go around,so i
prefer to go stight to the point,i assume is not good as well in those
cases,
i have 4 textboxes
cycle1,cycle2
this year,previous year
thats its
both are used to be a criteria in a query
sometimes i will need them to appear for example
cycle1 will show 1
cycle2 will show 2
CrtYear will show 2007
LstYear will show 2006
and sometimes i would like it to give this criteria for the query
cycle1 will show 1
cycle2 will show 1
CrtYear will show 2006
LstYear will show 2006
so the only time i''m making those changes is while clicking the
button,i do not give any the user any option to make any changes to
the criteria beside some logic that i have for the specific questioner
that i'm building
i hope its spreading more light on the issue
SusanV ???:

So... you need this change prior to building the table? I'm sorry, but
it's
very difficult to help you when you are so reluctant to explain what is
happening, getting the info in bits and pieces, it's like pulling teeth...


hi
the on click is buliding a table and populating it to excel
its very important that the textboxes will be correct otherwise it
will have wrong filters

SusanV ???:

What else is happening - is there more code than that in your event? Are
you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:

Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:
What exactly are you trying to do?

i dont see any results in the change,is it accuring doing the on
click?
mouse down seems to be one function before the on click without any
refresh form on the way
can you comment on this?

SusanV ???:
Use the On Mouse Down event rather than On Click
--
hth,
SusanV

Hi all,
I'm trying to build a code that will change textbox control
during
a
click,
for now without a success,i know there is a command called
refresh
or
requery but from some reason its just working after the click
event
has already finished,
is it posible to refresh the textbox during the click event?

 

[thread]

Hi
i configure it to be like this
i need to a wider range of criteria to have
cycle 1,2
this year,last year(appears as year(date() and year(date()-1
now sometime i need just to have 2 criteria but still there is 4
criteria for the query
so i'm just changing it boths to cycle 1 last year-(year(date())-1
all those 4 textboxes are used in the query this is why i need them
all
the form suppose to implement those textboxes in the query
but from some reason it seems like there is not change in the form
even that the change done in the code during on click

SusanV כתב:

No problem, glad to help - just simpler when I know what's happening on your
end <smile>

Not certain I understand your table structure though - if you have the
option of "This Year" or "Previous Year" in one field (control) why do you
need it in an additional field/control? It would be simpler to use a single
control, rather than trying to force the update of what appears to be a
duplication in function... Also what happens in 2008? Do we add another
field "2YrsAgo" to the table and shuffle the data so that 2YrsAgo holds what
is now in LastYear , and LastYear holds what is now in CrtYear, 2CrtYear
becomes empty?




i'm sorry for this,i just fill that it not good to go around,so i
prefer to go stight to the point,i assume is not good as well in those
cases,
i have 4 textboxes
cycle1,cycle2
this year,previous year
thats its
both are used to be a criteria in a query
sometimes i will need them to appear for example
cycle1 will show 1
cycle2 will show 2
CrtYear will show 2007
LstYear will show 2006
and sometimes i would like it to give this criteria for the query
cycle1 will show 1
cycle2 will show 1
CrtYear will show 2006
LstYear will show 2006
so the only time i''m making those changes is while clicking the
button,i do not give any the user any option to make any changes to
the criteria beside some logic that i have for the specific questioner
that i'm building
i hope its spreading more light on the issue
SusanV ???:

So... you need this change prior to building the table? I'm sorry, but
it's
very difficult to help you when you are so reluctant to explain what is
happening, getting the info in bits and pieces, it's like pulling teeth....


hi
the on click is buliding a table and populating it to excel
its very important that the textboxes will be correct otherwise it
will have wrong filters

SusanV ???:

What else is happening - is there more code than that in your event? Are
you
also using an OnClick? What are you clicking?

[form]![control].controlsource = "=1"

SusanV ???:
Yes, you said - but what code are you using?

i'm trying to change a textbox control source in order to make a
diffrent filter depending on diffrent values given on the screen

SusanV ???:
What exactly are you trying to do?

i dont see any results in the change,is it accuring doing the on
click?
mouse down seems to be one function before the on click without any
refresh form on the way
can you comment on this?

SusanV ???:
Use the On Mouse Down event rather than On Click
--
hth,
SusanV

Hi all,
I'm trying to build a code that will change textbox control
during
a
click,
for now without a success,i know there is a command called
refresh
or
requery but from some reason its just working after the click
event
has already finished,
is it posible to refresh the textbox during the click event?