Query or subform or both???

Hi Sarah,

Thank you for your question.

Sorry for the delay in responding.

Insert a combo box in the form header and use the wizard.

Select the option that says something like:

'Find a record on my form based on my selection'

2. Select the field that will display the GP Practice codes and add it.

3. On the final step rename the label to something like 'Select Practice code'

Then click Finish.

View the form and when you select a Code from the combo box, the records underneath should update.

I hope this has answered your question.

Regards

Simon