Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Forms (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=9)
-   -   Button for adding a record in a different table (after update) (https://www.access-programmers.co.uk/forums/showthread.php?t=302099)

Elie00 10-25-2018 04:56 AM

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.

missinglinq 10-25-2018 05:35 AM

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)>

Elie00 10-25-2018 06:12 AM

Re: Button for adding a record in a different table (after update)
 
It worked!! thx

missinglinq 10-25-2018 10:28 AM

Re: Button for adding a record in a different table (after update)
 
Glad we could help!

Linq ;0)>


All times are GMT -8. The time now is 05:48 AM.

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