Hello. I am brand new to Access. I have taken a beginner to advanced online course so I think I have a good base knowledge to start with. I am building an intricate database and I am currently stuck. I have created most of my tables, some forms, queries, reports & macros.
I have a menu with the command button "Run Job Info Form" which opens the Job List Name Form. I have a list box of all the job names, an OK button and an Exit button. The exit button works (pretty simple). I cannot figure out how to make the OK button do what I need to do.
I need the user to click on a job name, click ok, have the button open another form and apply the user selection (as a filter?) so that the form only pulls information for that job (it will be pulling from two or three tables using the same selection criteria). I would truly appreciate any help with this. I have looked at input boxes, macros, queries, VBA, and I just cannot figure it out!
Thanks!
I have a menu with the command button "Run Job Info Form" which opens the Job List Name Form. I have a list box of all the job names, an OK button and an Exit button. The exit button works (pretty simple). I cannot figure out how to make the OK button do what I need to do.
I need the user to click on a job name, click ok, have the button open another form and apply the user selection (as a filter?) so that the form only pulls information for that job (it will be pulling from two or three tables using the same selection criteria). I would truly appreciate any help with this. I have looked at input boxes, macros, queries, VBA, and I just cannot figure it out!
Thanks!