private sub listbox_click() combobox.rowsource = select fields from table where id = " & List0.Column(0, ListIndex) combobox.requery
end sub --- In [email protected], Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote: > > Hello, > > more help needed: > > if a have a combobox from a form which displays the ApplicationName using > > SELECT Variable.VariableID, Variable.ApplicationID, Application.ApplicationName FROM Variable INNER JOIN Application ON Variable.ApplicationID=Application.ApplicationID; > > i want to add this value to another table using the ApplicationName from the dropdown list as my filter criteria. > > SELECT Variable.ApplicationUserClassName, Variable.ParentApplicationUserClassName > FROM Variable > WHERE Variable.ApplicationUserClassName = <value selected from the combo box> > > how do i get the value from the combobox? > > thanks, > lyanne > > > L y a n n e R h e e z a C. O n g > > > > > > > --------------------------------- > Never miss a thing. Make Yahoo your homepage. > > [Non-text portions of this message have been removed] >
