Assign textbox Default Value to another textbox in Forms

Question

Hi,

I work as data entry and I have a lot of papers needs to be done, so I am trying to make my work smart as much as I can,

I have Form link to a Document table, and I have for example 2 fields I want to make default value textbox for them, this will helps me a lot becuse I do not want to repeat write them again and again, so plz help me to link this default value textbox with another fildes

txtBoxNum Link to  txtBoxDefultValue

txtBoxFolderNum Link to txtFolderDefaultValue

Kindly, use Expression Builder or Macros or Query

I will show you what I did but it does not work, I open the [Box Number] proprieties and in Default value expression builder I typed

=txtBoxDefultValue

[Folder Number] proprieties

=txtFolderDefaultValue

Answer 1

You need to use the Set Value Macro Action. In the property dialog select the OnCurrent event and then open the Macro Builder. Make sure you select to show All Actions. Then select the Set Value action. In the Item box type the name of the control you want to assign a value to. Then in the expression box select the control you are pulling the value from. 

Ex:

Set Value

Item = [City]

Expression = [DefaultCity]

Answer 2

Hi

Ok do it in VBA and I will try to do it by Macro

Plz indeed

Well, okay, see if this works for you.

In the AfterUpdate event of txtBoxDefaultValue, try:

Me.txtBoxNum.DefaultValue = """" & Me.txtBoxDefaultValue & """"

In the AfterUpdate event of txtFolderDefaultValue, try:

Me.txtFolderNum.DefaultValue = """" & Me.txtFolderDefaultValue & """"

Hope that helps...

Answer 3

Hi. I suppose it's possible using a macro, but you might as well get started with VBA since this is a simple one. Is that okay?

Answer 4

Hi my VBA at work is blocked, only Expression Builder,Macros and Query are working. I really appreciate your help and support. Plz

Answer 5

Hi

Ok do it in VBA and I will try to do it by Macro

Plz indeed