Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-25-2018, 04:56 AM   #1
Elie00
Newly Registered User
 
Join Date: Jul 2008
Location: Beirut
Posts: 21
Thanks: 7
Thanked 0 Times in 0 Posts
Elie00 is on a distinguished road
Unhappy Button for adding a record in a different table (after update)

Hey everyone!

I tried looking for the solution from within previous posts but couldn't find any! so i'm sorry if this might be a double post from someone else.

Anyways my issue is as follows:

I have a new "job" form and in it, i have a field called "Contact Name" this field is a drop down menu linked to a table of contacts i have already set up.
Now my issue is that if i have a new contact to be added, i want to add it directly using a button in the new job form that opens up a "new contact" form (already setup), i'll fill it up and it will be available in the drop down menu.

I know it's an after update thing, but i can't figure how it's made.

Thank you in advance for your help.

Elie00 is offline   Reply With Quote
Old 10-25-2018, 05:35 AM   #2
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,312
Thanks: 11
Thanked 719 Times in 669 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: Button for adding a record in a different table (after update)

What you're talking about is the NotInList event. Here's Allen Browne's excellent tutorial on the subject

http://allenbrowne.com/ser-27-01.html

Linq ;0)>
__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
Old 10-25-2018, 06:12 AM   #3
Elie00
Newly Registered User
 
Join Date: Jul 2008
Location: Beirut
Posts: 21
Thanks: 7
Thanked 0 Times in 0 Posts
Elie00 is on a distinguished road
Re: Button for adding a record in a different table (after update)

It worked!! thx

Elie00 is offline   Reply With Quote
Old 10-25-2018, 10:28 AM   #4
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,312
Thanks: 11
Thanked 719 Times in 669 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: Button for adding a record in a different table (after update)

Glad we could help!

Linq ;0)>

__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
The Following User Says Thank You to missinglinq For This Useful Post:
Elie00 (10-26-2018)
Reply

Tags
after update , button , form

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] VBA button to update every record in a table Locopete99 Modules & VBA 9 12-13-2017 06:17 AM
Adding a filter to the next record button Vitiositas Forms 2 11-05-2012 05:54 AM
record list doesnt update automatically after adding new record dimebagslash Forms 4 02-01-2011 06:51 AM
Vba code for add,delete and update a record in access table through command button? sunny1 Modules & VBA 1 07-28-2010 05:26 AM
adding new record by button Muneer Forms 0 07-22-2000 05:34 AM




All times are GMT -8. The time now is 09:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World