Subform / combo box

Any luck with an answer?

Hi Neal, note that I am delegate not a tutor but feel sure I can help.

Firstly I don't understand your first sentence. So if my guessed solutions below are not what you need then you can reply with more information such as, is your subform based directly on a table, a query or a form?

You can add a combo box into the subform and select the wizard option 'Find a record on my form based on the value I selected in my combo box'. Then select the town field and complete. You can then select from the drop down list or type in the town. You need to click out of the box for it to go. I like adding a small save or refresh button next to the drop down and put text on it saying 'Go' to make this intuitive.

Another solution if you don't mind re-inserting the subform is to choose to make the subform match a value on the main form (during the creation with the Wizard). If town is a natural ingredient of the main form and the main form is single (one record per form) then the subform will automatically go the correct town without any need to select from a combo box. Other solutions I can give depend on what the main form is based on, but options might include creating a simple small table to 'fool' the system. That table would have primary key and one field (call it SearchTown if you like), then include that table in the query that supplies the form and insert a combo box for that field. When you then create the subform you match the subform field Town to SearchTown. For the combo box (drop down list) source you insert a query to list the towns from where these are stored (using group by to list each once if needed).