Queries deliver data for subsequent querie on same form

[Danny]

I want to select values from a combo box which gets populated from a
querie. The selected data item from the combo box must be an input to
another querie which populates subsequent text boxes on the same form.

I cant get this to work, can it work?
Thank you.

 

[Guest]

Put docmd.requery in the after update event of the combo box.

 

[Pieter Wijnen]

Avoid using DoCmd when possible!

Me.Requery (in code)
Me.dirty = False (instead of DoCmd.SaveRecord) to name a few

As this gives you the oppurtinity for error handling

Pieter

 

[Danny]

Thank you, I did put a docm.requery, no success. Any further ideas?

 

[Guest]

In the second query do you have the criteria set on the proper column to the
control of the form? Is the combo box unbound? Can you please give some
more details.
Thanks