473,320 Members | 1,853 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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.
Mark
Sep 20 '22 #1
4 8201
NeoPa
32,556 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.
Sep 21 '22 #2
MNewby
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.
Sep 21 '22 #3
MNewby
27 16bit
I am not sure how to retract my question and cancel the post, but perhaps one of the sysops can.
Sep 21 '22 #4
NeoPa
32,556 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.
Sep 21 '22 #5

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

Similar topics

1
by: mfdatsw1 | last post by:
I have a .NET VB form that contains a Web Browser control. In the document in the Web Browser I have JavaScript that responds to certain click events within nodes (not buttons or other controls)....
7
by: TDIOwa | last post by:
I have a form that has a specific date on it. I want to open another form that has the Active Control Calendar on it. I want to open this form to the specific date on the first form. I have...
5
by: twick10 | last post by:
Hi, I am trying to execute a control method on an open form (not with focus) from a modal dialog box. I want to increment the node selected from the dialog when a certain key is pressed. Any...
0
by: mfdatsw1 | last post by:
I have a .NET VB form that contains a Web Browser control. In the document in the Web Browser I have JavaScript that responds to certain click events within nodes (not buttons or other controls)....
3
by: kev | last post by:
Hi folks, I have a form for registration (frmRegistration) whereby i have two buttons. One is Save which saves record using the OnClick property. I used wizard to create the save button. The...
1
by: mchlle | last post by:
I need for a form to display certain records based on the user. If current user = user1 or user2 then open frmNotesAll If current user = user 3 then open frmNotes where counselor id = 2 or 6 or...
14
by: keri | last post by:
Hi, Simple version of the question..... How do I use the where clause of the open form command to show an account with a matching ID to be displayed when the form is opened? Eg. I select a...
0
by: vidhyapriya | last post by:
Hi all, I am using two forms.From form1 button click i am opening form2,and i am passing values to form2 using delegate.when i click the button again form2 shouldn't open again but values...
5
by: billa856 | last post by:
Hi, My project is in MS Access 2002. In that I want to open one form multiple times. I put one button on my main form. Now whenever I click on that button than form will be open. Now when I...
5
by: mnaem02 | last post by:
I want to create button on tab control with VBA from different form. When i click to create button than with vba other form will open in a design view and create button on specific tab page. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.