Searching Problem

[RuralGuy]

How big is the zipped file? Try - a bunch at century tel dot net (without any spaces)

 

[RuralGuy]

Hi lauriphi,

I just tried my email with a zip attachment and it worked (~20Kb). Can you post it to this forum? Is this the problem you are still having?

...i go to click on the 14th record and the information from the 1st record still shows up in the text boxes below the search results.

Let's put some diagnostics in the AfterUpdate code:

Private Sub QuickSearch_AfterUpdate()
DoCmd.Requery
Me.RecordsetClone.FindFirst "[Name] = '" & Me![QuickSearch] & "'"
If Not Me.RecordsetClone.NoMatch Then
   MsgBox "Found [" & Me![QuickSearch] & "]"
   Me.Bookmark = Me.RecordsetClone.Bookmark
Else
   MsgBox "Could not locate [" & Me![QuickSearch] & "]"
End If
End Sub

 

[lauriphi]

yeah same problem as before, the one you had quoted above.. i just tried to send the zip again.. it is about 230k and was denied. im gonna run that diagnostic code you mentioned

 

[lauriphi]

ok so when i put that in the search terms i think it pretty much tells me why i am getting the problem... based on the search term you type in it identifies that record... but there are MANY other records that may contain the term that you used.. for example you type in "fred's steel works"" -- well there are 50 entries in the db for fred's steel works, each identifying different products or services rendered in the past.. but when you click on a specific "fred's steel works" entry in the search results box that are among the other 50 or so results that came up, the form goes to sync the record you clicked on with the editing feature in the lower portion of the form, but the search terms are too general to pick the exact one that you clicked on... does that make sense?

 

[RuralGuy]

Yes. You need to give your Suppliers an AutoNumber field and search on that field instead of the name.