Hi
I have a table with 3 fields (id,Task_id,description) and the values looks like
id task_id description
--------------------------
1 1444 aaaaaa
2 1444 bbbbb
3 1555 cccc
I would like to create a form with 3 unbound textbox and fill the textbox something like
The problem with that is it create 2 lines at the form but with the same last value
I would like too 2 line with aaaa and bbbb
Someine Can help me please?
I have a table with 3 fields (id,Task_id,description) and the values looks like
id task_id description
--------------------------
1 1444 aaaaaa
2 1444 bbbbb
3 1555 cccc
I would like to create a form with 3 unbound textbox and fill the textbox something like
Code:
dim rs as recordset
dim db as database
set db=CurrentDb
set rs=db.OpenRecordset("select * from TaskSub where task_id=1444")
do while not rs.EOF
me.textbox1 - rs("description")
me.textbox2 = rs("Task_id")
rs.MoveNext
loop
I would like too 2 line with aaaa and bbbb
Someine Can help me please?