By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,844 Members | 1,889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,844 IT Pros & Developers. It's quick & easy.

Text result to be copied to selected column in the sub form

P: 1
hi
I have Form Name as sdivsub_tbl1 and its sub from Name is sdiv_tbl subform2, when I click on subform VOCAB field the popup will appear(FRM_SearchMulti) as shown in the attached picture below, what I want here, when I click on selected search result the value field vocab is to be copied to sdiv_tbl subform2 vocab field where cursor placed in sdiv_tbl subform2 , can anyone help me to write the VBA code for this

Attached Images
File Type: jpg FRM search.jpg (187.6 KB, 25 views)
5 Days Ago #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,331
Good Morning shukoor
IHMO, the least intensive method is to have {FRM_SearchMulti} insert the selected value into the underlying table(s) followed by forcing the subform and parent form to Reqery (not Refresh) and have the parent return to the selected record, have the subform return to the active record, and then select the control on the subform

Another method, and the one I use most often, is to use form/subform/control references... perfectly doable

I have used both methods, really depends upon what I am doing, and the difficulty isn't that much more for the subform method versus table/requery method.
4 Days Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.