assigning value to the control (1 Viewer)

mana

Registered User.
Local time
Today, 09:28
Joined
Nov 4, 2014
Messages
265
hello

i attached my database
it is a web database
in form epm_info new i have a control as question and i wanted that the below sentence will be saved automatically for each field in this control

But I want that the question field will be automatically created each time based on Id field. ID field is autonumber field in table design
Such these:
Id=1
Then
Question= is epm info st-1 implemented?
Here in this sentence 1 = id
If
Id=2
Then
Question= is epm info st-2 implemented?
Here id=2

If id=3
Then question= is epm info st-3 implemented?
In this question id=3

i defined a variable when the form loads and assigned the below value to it
"is epm"&[id]&"implemented"
and then to the default value of my question control i gave this variable
it works
but for the first time opening of the form it doesn't work
after closing and opening for the second time it works
do you know where my problem is
i really need help
thank you
 

Attachments

  • nplsourcewith servicesharepoint.zip
    1.3 MB · Views: 132

aubrey1983

Registered User.
Local time
Tomorrow, 00:28
Joined
May 5, 2015
Messages
27
did you check the variables, and try to trace the macro or code, when the form loads?
 

Users who are viewing this thread

Top Bottom