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
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