473,224 Members | 1,361 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,224 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 8192
NeoPa
32,554 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,554 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. ...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

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.