View Full Version : A command button to go to a specific form


sofie
01-17-2002, 04:57 AM
This is already very good, but if I want to do this in an other form, and go to the specific form, what have I to do?
Can you help me?


If the command button is on the same form, you can try this
Me.Filter = "naam_kl = [Which Client are you searching for?]"
Me.FilterOn = True
naam_kl.SetFocus

wh00t
01-17-2002, 06:29 AM
Ignore the above, here's the code

DoCmd.OpenForm "frmKlantenfiche", acNormal
Forms!Products.Filter = "naam_kl = [Which Client are you searching for?]"
Forms!frmKlantenfiche.FilterOn = True
Forms!frmKlantenfiche!naam_kl.SetFocus

EDIT - easier than I thought it would be!

[This message has been edited by wh00t (edited 01-17-2002).]