Hi,
Have table with data ( like a,b,c,d in column 1), want to read data from table and put in text box in continuous form.
like tble name "tbltest" and textbox name "txtbox".
now want to read first data from table and put in text box, then read second one and put in text box .....so on unit finish data in table.
Try to write following code, but couldn't fiqure out ----" New in VBA"
Thx
*Please check attachment*
Have table with data ( like a,b,c,d in column 1), want to read data from table and put in text box in continuous form.
like tble name "tbltest" and textbox name "txtbox".
now want to read first data from table and put in text box, then read second one and put in text box .....so on unit finish data in table.
Try to write following code, but couldn't fiqure out ----" New in VBA"
Code:
Set db = CurrentDb()
Set rsLoc = db.OpenRecordset("tbltest", DB_OPEN_TABLE)
'Loop through records
rsLoc.MoveFirst
While Not rsLoc.EOF
txtbox =
*Please check attachment*
Comment