Update Text Box

[eclypz]

Whe i use a combobox, and i want it to update it's value i use the code

ME.cbxname.Requery

How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :(

[salad]

eclypz wrote:

Whe i use a combobox, and i want it to update it's value i use the code

ME.cbxname.Requery

How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :(

Let's say you have a combo box with 3 columns. There is a property
called Column that starts at 0. To reference the 3rd column, it could
be column(2)

In the AfterUpdate event of the combo box you could enter
Me.TextBoxName = Me.ComboboxName.Column(1)
to store the value of the second column into the text box.

[eclypz]

salad escreveu:

eclypz wrote:

Whe i use a combobox, and i want it to update it's value i use the code

ME.cbxname.Requery

How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :(

Let's say you have a combo box with 3 columns. There is a property
called Column that starts at 0. To reference the 3rd column, it could
be column(2)

In the AfterUpdate event of the combo box you could enter
Me.TextBoxName = Me.ComboboxName.Column(1)
to store the value of the second column into the text box.

Well, is not really that that i want...

What i want is this:

I have a form in which i have one txt box that presents the maximum
value in the table xpto.
to have this informacion, i have a query that give me the maximum, and
then the source in the text box is that maximum.

The value only update when i open the data base, but i want is that
when i click in the button to update the table, in the end of the
actualization that text box will present the new maximum.

Did u understand what i want?

Ah! the data in the table to be presented is date/time.

[Randy Harris]

* eclypz:

salad escreveu:

eclypz wrote:

Whe i use a combobox, and i want it to update it's value i use the code

ME.cbxname.Requery

How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :(

Let's say you have a combo box with 3 columns. There is a property
called Column that starts at 0. To reference the 3rd column, it could
be column(2)

In the AfterUpdate event of the combo box you could enter
Me.TextBoxName = Me.ComboboxName.Column(1)
to store the value of the second column into the text box.

Well, is not really that that i want...

What i want is this:

I have a form in which i have one txt box that presents the maximum
value in the table xpto.
to have this informacion, i have a query that give me the maximum, and
then the source in the text box is that maximum.

The value only update when i open the data base, but i want is that
when i click in the button to update the table, in the end of the
actualization that text box will present the new maximum.

Did u understand what i want?

Ah! the data in the table to be presented is date/time.

If the ControlSource of your textbox is something like:
=DMax("Col", "Table")

Add this to the end of the code that updates the table from your button
click.

Me.Recalc

That will cause it to "recalculate" that DMax value and update your text
box.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[eclypz]

Randy Harris wrote:

* eclypz:

salad escreveu:

eclypz wrote:

Whe i use a combobox, and i want it to update it's value i use the code

ME.cbxname.Requery

How can i do that to update the value of a textbox? i have already try
to use the same expression, but it doesn't work :(

Let's say you have a combo box with 3 columns. There is a property
called Column that starts at 0. To reference the 3rd column, it could
be column(2)

In the AfterUpdate event of the combo box you could enter
Me.TextBoxName = Me.ComboboxName.Column(1)
to store the value of the second column into the text box.

Well, is not really that that i want...

What i want is this:

I have a form in which i have one txt box that presents the maximum
value in the table xpto.
to have this informacion, i have a query that give me the maximum, and
then the source in the text box is that maximum.

The value only update when i open the data base, but i want is that
when i click in the button to update the table, in the end of the
actualization that text box will present the new maximum.

Did u understand what i want?

Ah! the data in the table to be presented is date/time.

If the ControlSource of your textbox is something like:
=DMax("Col", "Table")

Add this to the end of the code that updates the table from your button
click.

Me.Recalc

That will cause it to "recalculate" that DMax value and update your text
box.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

It Doesn't work :(

I don't know why...

I have this table with this name T00-Documents and then i have the text
box that had in de controlsource =Max([DateRead]![T00-Documents]), but
with this it always appear an error #Error... so what i did was. Create
a Selection Querie from the Table T00-Documents, and in the querie i
put this. Maximu:Max([DateRead]). Then in the controlsource just wrote
Maximu. And Like this it works.... but it only update when i open the
Form.

Now i don't know how to do :(

[Bob Quintal]

"eclypz" <eg*************@gmail.com> wrote in
news:11*********************@g10g2000cwb.googlegro ups.com:

Randy Harris wrote:

* eclypz:

> salad escreveu:
>> eclypz wrote:
>>
>>> Whe i use a combobox, and i want it to update it's value
>>> i use the code
>>>
>>> ME.cbxname.Requery
>>>
>>> How can i do that to update the value of a textbox? i
>>> have already try to use the same expression, but it
>>> doesn't work :(
>>>
>> Let's say you have a combo box with 3 columns. There is a
>> property called Column that starts at 0. To reference the
>> 3rd column, it could be column(2)
>>
>> In the AfterUpdate event of the combo box you could enter
>> Me.TextBoxName = Me.ComboboxName.Column(1)
>> to store the value of the second column into the text box.
>
>
> Well, is not really that that i want...
>
> What i want is this:
>
> I have a form in which i have one txt box that presents the
> maximum value in the table xpto.
> to have this informacion, i have a query that give me the
> maximum, and then the source in the text box is that
> maximum.
>
> The value only update when i open the data base, but i want
> is that when i click in the button to update the table, in
> the end of the actualization that text box will present the
> new maximum.
>
> Did u understand what i want?
>
> Ah! the data in the table to be presented is date/time.
>

If the ControlSource of your textbox is something like:
=DMax("Col", "Table")

Add this to the end of the code that updates the table from
your button click.

Me.Recalc

That will cause it to "recalculate" that DMax value and
update your text box.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

It Doesn't work :(

I don't know why...

I have this table with this name T00-Documents and then i have
the text box that had in de controlsource
=Max([DateRead]![T00-Documents]), but with this it always
appear an error #Error... so what i did was. Create a
Selection Querie from the Table T00-Documents, and in the
querie i put this. Maximu:Max([DateRead]). Then in the
controlsource just wrote Maximu. And Like this it works....
but it only update when i open the Form.

Now i don't know how to do :(

=Max([DateRead]![T00-Documents]) OR Max([DateRead])

should be Dmax("[dateread]","[T00-Documents]")

Also put in the form's AfterUpdate Event
me.textbox.requery and change textbox to the real name of the
textbox.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Randy Harris]

* eclypz:

It Doesn't work :(

I don't know why...

I have this table with this name T00-Documents and then i have the text
box that had in de controlsource =Max([DateRead]![T00-Documents]), but
with this it always appear an error #Error... so what i did was. Create
a Selection Querie from the Table T00-Documents, and in the querie i
put this. Maximu:Max([DateRead]). Then in the controlsource just wrote
Maximu. And Like this it works.... but it only update when i open the
Form.

Now i don't know how to do :(

Why didn't you post this to begin with?

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.