Update query subform

[putte11]

Hi,
I have managed to create a tab with a subform displayed as a database.
The subform is based on a query that picks criteria from a combobox above.
In the combobox I have 3 people no 1,2,3 i have set a default value of 1.
Starting the form works nicely and the def value is given to the query.
Now
How do I write an action when I change the combovalue to update the subform.


I managed to run the query but I want it to update the subform below the combo.
Lets call the subform "todo_pers"
Maybe I have misstyped the criteria as well , the combo is named "who" and the criteria states [Forms]![who].
The default value works initially.
As the combo has columns 1-no , 2-name with display on 2 , do I need to specify wich column to pick.
Thanks in advance!
P

[pbaldy]

It sounds like you want to requery the subform:

Forms!MainformName.SubformControlName.Form.Requery

If the bound column of the combo is the appropriate column, you don't need to specify it.

[putte11]

Ok you are propably right but where do I typ it.
If I put no action and just hit UpdateAll Im fine so maybe just an update all action.
How do I get an updateall action?
In this case "Forms!HUVUDFORM.Uppg_per_pers.form.requery" did not make it.
Thanks again.
P

[pbaldy]

Typically in the after update event of the combo. You can use VBA code or a macro. VBA would go here:

http://www.baldyweb.com/FirstVBA.htm

[putte11]

Yes I got that far and managed to Docmd openquery and it would open a new window. But thats not what I want.
Tried inserting
Forms!HUVUDFORM.Uppg_per_pers.form.requery
That did not work.
In 2010 I have a button for Update all that does the trick but I don't know how to invoke it by VBA.
P

[putte11]

Now if I type
Forms!HUVUDFORM.Uppg_per_pers.requery
I get error code 2465 runtime error
But if I type
Forms!Uppg_per_pers.requery
I get "cant find form Uppg_per_pers"
HUVUDFORM is my main form.

[pbaldy]

Can you post the db here?

[putte11]

Yepp !
Huvudform has tabs no3 Att gora ( To do in swedish don't know how this will turn out to you with some swedish letters)
is the one the bottom subform based on the query"HUS Ej klart pr pers" has a combobox on top VEM (who).
VEM has a default value of 2 and that is used initially by the query.
If I swap person in VEM I want the subform below to update. In ACCESS 2010 I can change person and hit the update all button and all is dandy, but when I use this from ACC2003 there is no Update button.
Patrik

[pbaldy]

It keeps locking up on me, but does this work for you (in the after update event of the combo):

Me.Per_pers.Form.Requery

You want the name of the control, not the name of the form.

[putte11]

Fantastic, thanks a million !
That was beyond me. Then again being a total rookie with no ACCESS education what so ever , I´m quite happy with what I have accomplished. These forums are of great help.
Patrik

[pbaldy]

Happy to help Patrik!