473,657 Members | 2,654 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

27 New Member
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
Sep 20 '22 #1
4 8224
NeoPa
32,568 Recognized Expert Moderator MVP
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 New Member
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 New Member
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,568 Recognized Expert Moderator MVP
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
687
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). How do I get information about the click event back to the parent VB form? I want the parent form to update certain information based on the ID of the node.
7
2746
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 searched this forum high and low to find a solution and have tried virtually everything mentioned, all to no avail. Some solutions even crash the computer. Does anyone have any ideas? Thanks TD
5
2459
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 help appreciated. Robert T
0
903
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). How do I get information about the click event back to the parent VB form? I want the parent form to update certain information based on the ID of the node.
3
10566
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 other one is Next button which i created to open another form "frmSummary" which displays back the records submitted. (i used the wizard to open form and find specific records to display. All these works superb until a review by users where they...
1
4516
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 9 or user3 ID If current user = user 4 then open frmNotes where counselor id = 1 or 3 or 8 or user4 ID If current user = user 5 then open frmNotes where counselor id = 4 or 5 or 7 or user5 ID If current user = user6 or user7 or user8 then close...
14
25037
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 record on a continuous form and click and edit button. The button runs the open form code. I want the APPID of the current record on the continous form to match the APPID of the record viewed
0
1056
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 should pass to already open form(form2) here i am added tab pages in tab control for every button click in one form. how to do this...anyone help me...thnax in advance Form1 Code:
5
7636
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 click again on that same button than it will open same form again in seperate window. But instead of that already open form comes.and so i couldn't open that form multiple times. Already open form must be remain as it is even if I click on that button...
5
3394
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. example i have four tab pages page1 page2 page3 page4 now i want to create button on page 2 ----------------------------------------------- Private Sub pos_Click() Dim FormName As String Dim tab_page As pages Dim frm As form Dim tab_control as...
0
8306
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8825
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6164
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4152
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1955
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1615
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.