find record

[Gruung]

I have searched this forum but i cant seem to find the awnser. I am sure it is something really simple. I have used the combo box wizard to 'find a record on my form based on the value i selected in my combo box'. It searches by last name and first name.

My form is based on a query so when you load the form it asks you which class you want to view. It all works fine except when i try to use the combo box it asks you which class you want to see, i want it so that it knows which class you are viewing. How do i do this?

thanks

 

[WayneRyan]

gruung,

No takers so far, so I'll take a shot at this.

You can set the default value for your combo so that when you
Open the form it won't ask for which class.

When you select a value from the combo, you can just do a
Me.Requery

If you adjust the RowSource for the query, you can have as its
criteria for the name:

Like "*" & Forms![YourForm]![YourCombo] & "*"

Or if you don't want the current record in the combo:

Like "*" & Forms![YourForm]![YourCombo] & "*" And
<> Forms![YourForm]![YourName]

Wayne

 

[Gruung]

thanks got it working