I am trying to update an older MS Access 2010 VBA script that is embedded into a button click. This button will update another Access table for another squadron. I need to change a couple things around however because my update will basically break this script by not sending all the required information.
What needs to be done is there is a "Top3Commen ts" and a "Call Sign" entry that have their own boxes. What I...
Haagimus
Last Activity: Oct 8 '13, 07:19 PM
Joined: Sep 10 '13
Location:
-
Concatenate in a VBA "INSERT INTO" script
-
Fantastic that fixed that. Now when I update the second combo however it changes every second combo in the subform?
**Nevermind, just realized the table that the data writes to does not have a commander block in it, adding it should fix the problem. Thanks Seth you da man. -
This is the script that is running directly from the query itself. Now when I run this either from the query directly or through the form it...Code:SELECT Personnel.[Name-Last] FROM Personnel WHERE (((Personnel.[Name-Last])<>"") AND ((Personnel.[Home Station Organization])=[Forms]![Ops Sup_Mission Subform]![Squadron]) AND ((Personnel.[Duty Status])="Present")) ORDER BY Personnel.[Name-Last];
Leave a comment:
-
Combo Box to declared variable for second combo lookup query
I am trying to create an access form that will have multiple combo box drop downs. There are two that will need to be linked in the form. The selection of the first will need to become the query criteria for the second. Everything I try ends up popping up a box and asking for inputs instead of running the query.
***This also needs to be a one time variable as the form has a subform that creates new entries for missions as needed so...
No activity results to display
Leave a comment: