help ms access

[hybrid_X]

---

how to find record ha access w/o using the look up wizard? example akong key field =or_id

pag magclick ako sa button i locate na niya ang record sa form w/ datasource.

[cebutech]

simple way to do this is by creating a query. it's difficult to show that here...
another way is by using a SELECT statement which retrieves the data you want and then changing the datasource of your form.
something like the one below.

Button_Click event

Private Sub btnMyButton_Click()
Forms!your_formname_here.RecordSource = "SELECT your_fields_here, FROM tablename where or_id = '" & Me.your_textboxname_here & "'"
End Sub

if you do this, the only records that will appear to yous form will be those records where or_id = the order id u typed in the textbox