Subform update

[jax]

I have a main form which lists premises info, name address etc. A command button opens a subform in which information about the use of each individual room within that building is entered. My problem is that I want, on click of a button on the subform, for all the rooms relating to that particular building be shown as a list on the main form. I have the list showing but when I enter another room it overwrites the top entry on the list.

 

[Pat Hartman]

You need a separate unbound control if you want to be able to find new records using it. If you use the wizard to build a combobox, "finding a record for the current form" will be an option.