Forum home » Delegate support and help forum » Microsoft Access Training and help » Query or subform or both???
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Query or subform or both???
Resolved · Medium Priority · Version 2003
Reply Tue 3 Aug 2010, 14:39Delegate Sarah said...
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?
For upcoming training course dates see: Pricing & availability
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
|