Form with dropdown/type keyword

[Guest]

I am trying to create a form where a bunch of info would be entered,
including some keywords. I would need that keyword "box" to:
1. display a dropdown list of term already in the keyword database (so that
people don't enter several times the "same word" with diferent mispells)
2. enalbe successive keyowrd selection (like a list)
3. allow the user to add a keyword if need be directly from the entry form.

I tried to create a subform, but I am running in circle for the last four
days. I manage to have my subform display a rolldown list of the exiting
keywords and display them as selected into a small speadsheet into the entry
form, BUT I cannot get it to allow any new keyword entry, which is an
important part of it since that keyword option is brand new and the list very
short. Maybe I am going at it the wrong way. I saw the option of the combo
box in the subform, "limit to list" but that requires the bound column to be
visible apparently and when I tried that it screws up the keyword display
(for some reason, only the key parameter displays, even if I tell Access to
display both column)

Anyone has done those kind of things before? I would assume it would be the
same problem if you wanted to create a video library and trying to enter a
new video with exsiting actors form a menu or adding one (without havignto go
to the "actor table")...

Thank a lot.

Marie

 

[Douglas J. Steele]

LimitToList doesn't require that the bound column be visible. However, if
you're adding a new record to the underlying recordsource, you need to
ensure that you capture all of the information required for that new record.

If the bound field's an AutoNumber field, you should have any problem: the
sample code in http://www.mvps.org/access/forms/frm0015.htm at "The Access
Web" would add the new record, setting AEName to the text, and having the
autonumber field automatically generated.

For anything else, you may need to pop up a form to capture all of the
information.

 

[Guest]

Thank you very much it worked like a charm, and I applied the same principle
to other part of the form... thanks again.