assign value froma table to a text box (1 Viewer)

R

Richard Flame

Registered User.

Local time

Today, 14:02

Joined

Mar 21, 2007

Messages

11

• Dec 3, 2008

• #1

hello all,

how can I possibly assign to a textbox the max value loacted in a field called "Volume" in table called "Curr".

I have tried to use DMax("Volume" , "Curr") from the expression builder but nothing happens. tks in advance

Rich

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 14:02

Joined

Aug 30, 2003

Messages

36,133

• Dec 3, 2008

• #2

That should work. If it's the control source of a textbox, there would need to be an equals sign in front.

 

R

Richard Flame

Registered User.

Local time

Today, 14:02

Joined

Mar 21, 2007

Messages

11

• Dec 3, 2008

• #3

Thanks..it works great..I was not including the =

AAAH!

 

R

Richard Flame

Registered User.

Local time

Today, 14:02

Joined

Mar 21, 2007

Messages

11

• Dec 4, 2008

• #4

Hello all,

The solution posted earlier works great except that the value does not get updated in the form once it's deleted from the table, unless I close the form and open it again.

Is there any way to quickly reflect the changes once the max value is removed from the table?

Thanks

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 14:02

Joined

Aug 30, 2003

Messages

36,133

• Dec 4, 2008

• #5

Try and requery the control:

Me.ControlName.Requery

in the appropriate event.