Update a combo box

[SJW]

I have a well functioning database that sorts hundreds of publications based
on three cascading combos. - category, subcategory and publication (title). I
have it set-up that on one form (FmAddNew) the user selects a category from
the first cbo, then a subcategory which is linked to the category cbo. On
this form, the user enters the title into a text box. All other details are
text boxes within a subform.

On another form (FmView) the user is able to retrieve a publication via
three cbos. Firstly they select the category from a cbo, then the subcategory
from another cbo, and in a third cbo, all publications under that
category/subcategory combination are displayed in a drop-down list. The user
can then select the title of a publication and all details relating to that
publication are displayed.

On FmView, the user can also edit publication details if required. However,
they are unable to edit the publication title within the third cbo. I am
having difficulties trying to devise suitable code, so any advice greatly
accepted.

thanks
Steven

 

[akphidelt]

What do you mean by

"They are unable to edit the publication title within the third cbo"?

 

[John W. Vinson]

On FmView, the user can also edit publication details if required. However,
they are unable to edit the publication title within the third cbo. I am
having difficulties trying to devise suitable code, so any advice greatly
accepted.

Well... you're not editing *the combo box*. A combo box is not data; it's a
tool to display data!

Where is the publication title stored in your tables? What is the Recordsource
of the form? Is the publication title one of the fields actually on the form,
or does the form's recordsource contain only the publication ID?

John W. Vinson [MVP]

 

[SJW]

OK
Publication title is stored on tblPublications. The user enters the
Publication title on FmAddNew into a text box. When the user wishes to view a
certain publication, they use another form, FmView, and select the
category/subcategory combination. Then all titles are displayed on the third
cbo.
The recordsource for FmView is: SELECT * FROM tblPublications ORDER BY
Publication;
The three cbos are on the main form of FmView, the other fields are within a
subform.
I'm not sure whether this adequately answers your questions, any advice
appreciated.
thanks
Steven