Search results for query: *

It worked thanks. I copied the SQL from the query and pasted it in a RunSQL macro using AfterInsert. cruzan

I have a form to add systems to a systems table. And I have an append query called QuestionSystem that adds to an answer table. How would I run this query from my add systems table?

I was able to get it to work by puting Combo10.value = Me.[SystemID] in On Current event procedure of the Form. Thanks for the help, cruzan

Neither of these worked. I'm probably not doing something right. Do I just put the code in the properties box, or do I need to go into the actual event procedure? The name of my combobox is Combo10. The field it uses is named System Acro from table Systems1. The form is just named Form When I...

I have a combo box made using the wizard that Goes to a selected record. It updates the rest of the form fine. But, when I use the record navigation at the bottom of the page the, the form updates except for the combo box. How do I get the combo box to change along with the form?

WOW, that was easy. Thanks!

I have a Value list that filters a subform based on Question Type ("BackgroundQ";"Main SystemQ";"Web LayerQ" ...etc). The subforms criteria for QuestionType is [cboFilter].[value]. How would I add an "ALL" to the value list to show all the Question Types in the subform?