Solved

I want to update a access field on a from from another form

Posted on 2011-09-29
11
177 Views
Last Modified: 2012-05-12
I have an access form (see attached) that I want to update a field from a popup form when the user double clicks on his/her selection.
SignIn.docx
0
Comment
Question by:shieldsco
  • 6
  • 5
11 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36814929
what is the RowSource of the combo box Provider Name in the Login form?

you can use the double click event of the field FullName from the form Service.. to select the value from the Provider Name combo box, but this will depend on the RowSource of the combo box.
0
 

Author Comment

by:shieldsco
ID: 36815189
The RowSource of the combo box Provider Name is SELECT [tblEmp].[FullName], [tblEmp].[Service] FROM tblEmp ORDER BY [FullName];--  I would lke to give the user the option to select from the combo box or the from the form Service
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36815229

try this, change object/control names accordingly

private sub FullName_DblClick(Cancel As Integer)

Forms!Login.cboProviderName=Me.FullName

end sub
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:shieldsco
ID: 36815463
I get the following error :run time error 2465 application- defined or object defined error
Private Sub FullName_DblClick(Cancel As Integer)
Forms!frmSignIn.cboProviderName = Me.FullName
End Sub
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36815553
delete this codes first

Private Sub FullName_DblClick(Cancel As Integer)
Forms!frmSignIn.cboProviderName = Me.FullName
End Sub

try this code

Private Sub FullName_DblClick(Cancel As Integer)
 msgbox Me.FullName
End Sub

did you see the message box with the correct name ?
0
 

Author Comment

by:shieldsco
ID: 36815629
Yes
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36815679
create a .MDB version and upload ...
0
 

Author Comment

by:shieldsco
ID: 36815763
ok see attached - select Check-In from the main menu and then double click on Provider Name to get the popup form Service
SignIn-V1.mdb
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 36815831
the combo name is ProviderName not cboProviderName


here is the code

Private Sub FullName_DblClick(Cancel As Integer)
Forms!frmSignIn.ProviderName = Me.FullName
End Sub
0
 

Author Comment

by:shieldsco
ID: 36816058
Thanks -- good job
0
 

Author Closing Comment

by:shieldsco
ID: 36816066
Very good
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Restoring a form to its default settings 3 27
backup programme - VBA 3 24
MS Access Delete All Excel sheets 1 9
Microsoft Access Reports & Sub Reports 3 14
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question