Passing argument from subforms to main form

[DanT]

Hi there, I'm looking for a way to pass an argument from subforms to a main form. Below is a simple form to assign contact to address. I'd like to pass Site ID and Contact ID to the main form by selecting relative records from subforms. This works great the other way around by showing already assigned values, but I'd like it to be an entry form. Normally combo box would cut it but I'm expecting many records in both tables and as far as I'm aware there's no option to sort and filter combo boxes by end user, hence subforms. Would someone please point me the easiest way to do this?

[June7]

This is what comboboxes and listboxes are for. However, if the subforms are not linked to main form, some event code could populate the main form textboxes. Real trick is figuring out what event. Perhaps the form Click event. User would have to click on the record selector area on left side of form.