Form to Retrieve and edit data ???

[WineSnob]

I have a simple form with a header with 2 fields 1 unbound for year and 1 combobox for vendor. I have a button with this code:
Private Sub Command36_Click()
Me.Requery
End Sub

In the detail section I have the fields I want to see and edit from a query with the detail section default view set to Continuous Forms. All works well EXCEPT if I select a "vendor" and then Select a different "vendor" without making changes it changes the vendor name to the new vendor Is this a focus issue?

All I want to do is use a form to retrieve data and filter it based on the 2 fields, display the data and edit as necessary and close the form.

What am I doing wrong PLEASE?

 

[pbaldy]

It sounds like your search combo is bound, and it shouldn't be.

 

[WineSnob]

That would do it...... Thanks.............

 

[pbaldy]

No problemo! I think I'll have a nice Cabernet tonight.

 

[WineSnob]

As am I. 1997 Jordan for me.
You desereve it.