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

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

P: 1
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, 183 views)
May 18 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
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.
May 18 '19 #2

Post your reply

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