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

[MNewby]

I have a form named CAD_CallDispSpl itF 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_CallerA ndVehicle that has two subforms: frm_CADcaller and frm_CAD_Vehicle s. 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_CallerA ndVehicle, and setfocus on the VehTop control on the frm_CAD_Vehicle s subform.

Thanks in advance.
Mark

[NeoPa]

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.

[MNewby]

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.

[MNewby]

I am not sure how to retract my question and cancel the post, but perhaps one of the sysops can.

[NeoPa]

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.