471,321 Members | 1,662 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,321 software developers and data experts.

Button to open form where ID=ID, and setfocus on a certain control

27 16bit
I have a form named CAD_CallDispSplitF with a primarey key as ID in the underlying record source. The form has a command button, btn_addVehicle.

I have another form named frm_CAD_CallerAndVehicle that has two subforms: frm_CADcaller and frm_CAD_Vehicles. The subforms are NOT on individual pages. Each subform is linked to the parent form on ID.

Either through VBA or Macro, I need an On-Click event on the btn_addVehicle button to open form frm_CAD_CallerAndVehicle, and setfocus on the VehTop control on the frm_CAD_Vehicles subform.

Thanks in advance.
1 Week Ago #1
4 4173
32,405 Expert Mod 16PB
Hi Mark.

Please understand that your question reads more like a requirement specification - and that's not cool. We help you with your work. We don't simply do it for you.

Feel free to explain what you've already done and then I'm sure we'll be delighted to jump in and get you going on the right track.

I have to say you've included good detail with the names of the objects and all, but we're constrained from answering such questions when posed simply as requests for work.
1 Week Ago #2
27 16bit
NeoPa, I am sorry if you took it that way. I am NOT asking anyone to do my work for me, and to just assume that I am and write so in a response for everyone to read, is too not cool. I included as much detail as I could about the structure to help everyone understand exactly what I am needing. I don't expect anyone to write the code for me unless they absolutely want to. I am on this forum to seek guidance and education on how to achieve my objective MYSELF when I don't yet have the knowledge.

I am working on a huge project and am proud of what I have accomplished MYSELF with just beginning to understand VBA. I have, of course, gotten some helpful suggestions from people like yourself on these forums but to be honest with you, I doubt I will ask for help again on this forum given your response. Thank you anyway for all the help you gave me in the past.
6 Days Ago #3
27 16bit
I am not sure how to retract my question and cancel the post, but perhaps one of the sysops can.
6 Days Ago #4
32,405 Expert Mod 16PB
I have replied via PM. Please let me know how you wish to proceed.

As explained in the PM I should be sorry to see you leave.
6 Days Ago #5

Post your reply

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

Similar topics

1 post views Thread by mfdatsw1 | last post: by
reply views Thread by mfdatsw1 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.