How to create a field in a table automatically

[mana]

Hello

I have a form and it has a field as question
I also have a field as I'd in this form from the same table that is autonumber
I want that for each field the question will be created automatically in the table as below:
Is epm ( my Id field) is created
Is epm and is created are string
They should also include Id number of each row
So It would be like
Is epm -1 implemented
Is epm-2 implemented
.
.
For each row
Can you help me please?
I don't know how to do this?
Thank you

 

[JLCantara]

Can you find someone who could WRITE this issue in clear English? As is it's impossible to find out what your talking about...

 

[jdraw]

mana,

I agree with JL. I've seen several of your recent posts and can not understand WHAT you are asking.
Can you try to restate the issue; show some data before; and your desired results?
If English is not your mother tongue, please write a description in your native language and use google translate to get English. We can not respond clearly until we understand the issue. And your submitting additional posts is not an efficient strategy.

Readers are willing and wanting to help, but we have to understand WHAT you're trying to do.

 

[mana]

Actually, I have a form with some fields
The recordsource of the form is a table
This table has some columns as Id, question,info,...
I want to insert data to this table within this form.
But I want that the question field will be automatically created each time based on Id field.
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

Then I press insert button and data will be inserted
Id field is autonumber

I hope I were clearer this time
Do you have idea?
Thank you

 

[jdraw]

Based on your latest post:

You have a table with some fields (table)
One field (ID) is datatype autonumber.
You have a form bound to the table (bound form)
You want to store records in the table
The form will be used to enter the data to be stored in the table (date entry form)
The record will be saved to the table when you move from the record. That is, you do not need a button on the form necessarily, simply move to the next record and the record just entered will be saved.

see this link for info on data entry form

Note: If you have a designed table with an ID field having datatype autonumber, then
the autonumber will be populated automatically by Access - you do NOT have to supply a value for the autonumber field in the record.

You could also search for youtube video on Access data entry forms.

Good luck.

 

[mana]

hello

thank you for the information

i have a severe problem here
i did it as below:

i defined a variable when the form loads and assign the below sentence to it
"is epm"&[id]&"implemented"
and then i gave to default value of my question control, this variable

and it works
but i don't know why it doesn't work for the first time and after closing the form for the first time it works. can yu guide me please?

 

[mana]

i also attached my database
it is a web database in ms access
and my form is epm_info new

 

[jdraw]

I don't use sharepoint.

Again, I must highlight that when you post a question in a forum, you should give the whole picture to help readers put your question into context.

You have an Access/Sharepoint environment --this could/should have been identified in your overview in your first post.