Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selector

Status
Not open for further replies.

gasx

Technical User
Feb 28, 2003
22
US
I use this code to select one item from the list box to enter into text box in my ms access form.
on click event I insert this code.

list10.value=text10.value
text10.setfocus
list10.visible.false

this code is working fine. how can i use this code to to select item form subform instead of list box.
 
I will assume you are in the subform making your selection from a list for a textbox on the main form. If that is the case, then something like this should work:
Me!list10.value = Me!Parent!Text10.value
Me!Parent!Text10.setfocus
Of course you may have to make a few minor modification, but this does exactly what your procedure did, assuming the list and the command button are on the subform. If the command button is on the main form, this procedure will have to be modified, but it will still work in principle. Hope this helps, goos luck.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top