Using a form to populate dialog lists on another form.

[rridsdale]

Can anyone tell me what the code would be to make a dialog list field from a form look at a field on another form for the list of choices. I have seen this done before where there is one form that contains a field for every list on a different form but just cant figure out how to do it. The object here is that I can make someone the administrator of the database then they can update list changes without needing designer.

 

[pmonett]

It's not difficult. You need to define a view, lets call it Keywords. You then need to define a form, you can call it KeywordList. In the form, define two fields : a Key field, and a List field. Both should be text fields, but List needs to be multi-value.
Set the Keywords view so that it accepts only Keyword documents, and create two columns. The first should display the Key field, the second should display the List field.
All you need to do now is create Keyword documents with the data you need. In any other form of the database (or indeed, of any other db on the server), you can now use @DbLookup formulas to find the corresponding keywords, and you have no problem with handing over the maintenance of keyword lists to a user.

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.