Docmd.OpenForm ?

[WineSnob]

I have a form that I select the CLient and then want to open another form with the client data. The following works EXCEPT I have to hit the Refresh ALL button and It refreshes the form and returns all the data.
Probably something simple... Thought the Me.Refresh would work.Thanks

I tried to use the where condition argument but could not get the syntax.
The Forms!frmSelectClient!CmbClientSelect.Value is text
I also have an ID field on the forms which is a long integer. I could use it too.

Private Sub btnGetClient_Click()
DoCmd.OpenForm "frmInput", acNormal
Forms!frmInput.Client = Forms!frmSelectClient!CmbClientSelect.Value
Me.Refresh
End Sub

 

[pbaldy]

Is this what you're trying to do?

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

 

[WineSnob]

Thanks. I couldn't quite get the syntax right. Also my second form was based on a query looking for criteria from that form. I got it working now.
Thanks

 

[pbaldy]

No problem, glad you got it sorted out.