Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course
Query or subform or both???
I've got a form in access and it has an option to select a GP Practice code (I have the GP Practice Code table set up so am using that).
What I want to do, is when the user selects the GP Practice Code from the drop down list, I want the name of that Practice (which is in the GP Practice Code table) to pop up on my form.
How do I do this?
RE: 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
