98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Linking a sub form to an unbound combo box | Access forum
Linking a sub form to an unbound combo box | Access forum
Resolved · High Priority · Version 2007
Wed 27 Jun 2012, 10:14Delegate Marc said...
Marc has attended:
Access VBA course
Linking a sub form to an unbound combo box
Hi
I have a form with a couple of unbound combo boxes with the values of AdviserName and SCIID (ref no of the project).
How it works is that when you choose the Adviser Name, the second combo box displays the assignments which pertain only to that Adviser.
However, what I need next is to have sub form which has all the fields where the Adviser makes claims for the particular assignment. So i need to linked the sub form to whatever value (SCIID) is chosen in the combo box.
For example, if I choose MLF000300, then the the cliam information pertaining to that record will be shown in the sub form. I can normally link sub form to master forms using child and master fields, but of course, as I am using VBA, it is more dififcult.
Any help please for the coding that will solve this?
thanks
Marc
Wed 4 Jul 2012, 19:16Trainer Anthony said...
RE: Linking a sub form to an unbound combo box
Hi Marc, thanks for your query. This is definitely something requiring code.
The code will be placed in the AfterUpdate event of the SCIID combo box.
You'll need to pass the value of that combobox to a variable.
You will need to concatenate that variable into a SQL query retrieving the values you want to put into the sub-form.
You'll need to set the rowsourcetype of the form to "Table/Query" and the rowsource to your SQL.
If you've retrieved multiple fields via the query you'll need to set the columncount to match that number, otherwise you won't see much.
A lot of this is already in our training code, but the combination of techniques is what differs out in the real world and is often not immediately obvious. Have a go and see how you get on.
Anthony
Wed 11 Jul 2012: Automatically marked as resolved.
Training information:
|
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. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
