S
stgeorgeconvent
have a comboBox with two columns. I would like to isolate each column
so
as
to compare it to an entry in a table so as to be able to load a yet
another
form. how can I do that?
Details: The form is called MasterForm, it has a two columned comboBox
called
InsPVComboList. "Text.[column](0,0)" is my attempt to add to the where
condition in the macro to isolate each entry in the combobox. I have
tried
Inselection.[column](0,0) but it did not work.
The code is as follows:
Forms![MasterForm]![InsPVComboList].Text.[Column](0,0)=[RejectionsTable]![Parts_#])
And
([Forms]![MasterForm]![RejPVComboList].Text.[Column](0,1)=[RejectionsTable]
![Vendor_Name])
Thanks
Mike
so
as
to compare it to an entry in a table so as to be able to load a yet
another
form. how can I do that?
Details: The form is called MasterForm, it has a two columned comboBox
called
InsPVComboList. "Text.[column](0,0)" is my attempt to add to the where
condition in the macro to isolate each entry in the combobox. I have
tried
Inselection.[column](0,0) but it did not work.
The code is as follows:
Forms![MasterForm]![InsPVComboList].Text.[Column](0,0)=[RejectionsTable]![Parts_#])
And
([Forms]![MasterForm]![RejPVComboList].Text.[Column](0,1)=[RejectionsTable]
![Vendor_Name])
Thanks
Mike