Hello,
I have a combo box with three fields: ID, Funds, Exceptions. These fields are linked to a query and the query has been created from a table called "DailyPrices". I would like to use the ID record from the Combo box to search for it in the table "DailyPrices" and provide me the information contained in another field of the table called "Exceptions" which is related to that particular ID. The "Exceptions" field from the table is a memo field. I would like to include this field in the form which includes the combo box is so users can update the table using the form. is this possible?
I tried to use a text box linked to the combo box including Dlookup in the data control source but it doens't work. I read that memo fields can't be indexed, is that the problem?
Jose
I have a combo box with three fields: ID, Funds, Exceptions. These fields are linked to a query and the query has been created from a table called "DailyPrices". I would like to use the ID record from the Combo box to search for it in the table "DailyPrices" and provide me the information contained in another field of the table called "Exceptions" which is related to that particular ID. The "Exceptions" field from the table is a memo field. I would like to include this field in the form which includes the combo box is so users can update the table using the form. is this possible?
I tried to use a text box linked to the combo box including Dlookup in the data control source but it doens't work. I read that memo fields can't be indexed, is that the problem?
Jose
Last edited: