Passing Data from One Form to Another Form: MS Access

hello they come back to my video tutorial for Microsoft Access 2010 and in this video I will show you how to pass the data form another form to this form I have the example the database we call all need to check out page need to select the vehicle name the call number and me to select employee name if the employee is not on the list here and we need to add new employee and then after we close need that employee name to show in here for example we see the employee's name when they check out the John John when you see when I click enter say the name you induce not on the list it's not on this list I just to make an ad one another person and I go to add new and John when an employee name or number and close the other close John when we show up here and any code and next step I will show you how to add code on this form and pass this information to another form go to design view on this employee add new employee form we use it on the course the even position after we close now the password protection for my with the code you see I have the command here before we close and have the close command before I close I do this rephrase the form and the form is the name is food name employee name and if is no awful name and then do nothing else the form navigation form because I want to pass that to navigation from here and this form is under it's a sub form of navigation form and then I put dot and dot form and darn invocation form dot use of God for medusa and me dot dot user dot equal to me don't stop ID user is the name on another form right here you could assign view on this one you see the user the name of this view is user okay we can try them all we can use this function if not is no fooling and if we have the parentheses and then we do this one perform not maybe Asian we use a bracket because the name the form is we have to paid in their form dot navigation munication subform the form the user dot do so equal to me dot stop ID waste a by D star by D is equal to the this one the current form and then we use the same thing me a copy we just want to focus on that one not me you sit up sit forgotten okay and then after that impose the two men save on and also on this form on the even we also put on the course you went to in course somebody put on post button on the right and corner you see both under Jose when we also set the same thing over here to go to view hold it for now because this one recur is not working a reason why this form is not it's under design we design mode yes okay support save and called this maybe now I want to add someone else like tazing name on one and we could cause now it's tasting name is show over here on this one on this user take field and we can process another step up the code is just beginning this mean has the information when we enter the new name new employee and pass that information to another form using this make sure that form name is correct something we have a navigation form for an update on navigation subform and the field name is used equal to the ID because this one is drop off is linked to the by employee ID because this job is linked to the ID from another table from employee table and hopefully help you on something like a passing the information from one form to another form thank you for watching

Channel: T Golden Eye

Views: 211,092

Rating: 4.5405941 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, copy data to another form, passing data from one form to another form, update data from another form, fill in data with data from another form

Id: IIRaSARt2eQ

Length: 7min 39sec (459 seconds)

Published: Sat Mar 29 2014