Change the value of a text box in Form

E

emerlita

Hi.

I have a textbox named PseudoCLLI that and i want this Auto-generated
suggested value equal to the ShortCLLI. How do i do this? PLUS, it is
suggested meaning i can overwrite what's there.
 
R

Rick Brandt

Hi.

I have a textbox named PseudoCLLI that and i want this Auto-generated
suggested value equal to the ShortCLLI. How do i do this? PLUS, it is
suggested meaning i can overwrite what's there.
Click to expand...

In the AfterUpdate event of the ShortCLLI TextBox...

Me.PseudoCLLI = Me.ShortCLLI
 
S

Steve

Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
E

emerlita

Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]







- Show quoted text -
Click to expand...

both of these suggestions didn't work.
In the table, still shows blank entries in PseudoCLLI.
In Form, same, still blank.
 
S

Steve

You did not do something right! What is the controlsource of your textbox
PseudoCLLl? Is it a field in your table? Did you enter "ShortCLLl" as the
default value of that field in your table?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
E

emerlita

You did not do something right! What is the controlsource of your textbox
PseudoCLLl? Is it a field in your table? Did you enter "ShortCLLl" as the
default value of that field in your table?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]







- Show quoted text -
Click to expand...

OK, now it works except for when i changed the PseudoCLLI, this
changes the ShortCLLI too.
What i exactly want to do is have it this way(above) but when i try to
change the PseudoCLLI, shouldn't change the ShortCLLI at all and they
won't have the same value after the pseudoCLLI changed. The first
event applies only when the PseudoCLLI don't get overwritten.
Hope this makes sense.
 
S

Steve

You don't need the code. Just set the default value for the PseudoCLLl
field.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
E

emerlita

Open your table in design view. Select the field that the textbox PseudoCLLI
represents. In the bottom section enter "ShortCLLI" for the default value.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]







- Show quoted text -
Click to expand...

OK. now, i took out the code out and tried to add the default Value as
"=ShortCLLI" but this one gives me "ShortCLLI" as the actual value of
my PseudoCLLI.
 
Top