Member Avatar for isumasama
isumasama 0 Newbie Poster

hi i have this form, and a subform datasheet.i need to copy selected row/record from the datasheet to the corresponding textboxes. i have used this, but it will copy the whole column title and the record, and i dont know how to separate the string of copied data into textboxes,
if anyone get this, can u pls help. thanks a lot.

...
DoCmd.GoToControl "OpNameClick" '1 of the textbox to check the paste command
DoCmd.RunCommand acCmdPaste

the copied value:

ProcessBlock	Purpose	OpName	OpDescription	TechName	IDProc	IDTech	IDRemark	ProcessNum	Step	IDOp
		1020	LC START LOT	SFET3HV80RG	1	9		1	1	1
Edited by isumasama because: n/a
  • 1 Contributor
  • 0 Replies
  • 71 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.