Search button on forum

[amerifax]

My first attempt on this board for help was trying to create a method to search using Access 10. After no response I noticed on the bottom of the topic this link which was very helpful:
<http://datapigtechnologies.com/flash...tomfilter.html>

This was my first attempt at code with Access 2010 or for that matter any program. It was easy to follow and the result was pretty decent considering I have zip experience. I did come up with a problem that's beyond me, no surprise there.

I have a button to clearer the filter and when I click on it I get this error message: "Enter a parameter value" Forms!form!myselector

Here is a code for the button (On Click):
Option Compare Database
Private Sub Command89_Click()
Me.myselector.Value = ""
Me.Requery
End Sub
______________________________
Private Sub myselector_AfterUpdate()
Me.Requery
End Sub

The following is the Query:
SELECT PERMIT.SEQNO, PERMIT.SEAL, PERMIT.PER_DATE, PERMIT.IPDATE, PERMIT.SC, PERMIT.TYPECITY, PERMIT.BLD, PERMIT.BLDNAME
FROM PERMIT
WHERE (((PERMIT.SEAL) Like [forms]![form1].[myselector] & "*"));



Hope to find some help on this forum.

I also would like to know how to create a button that will let me toggle between column view and forum view. My company was vandalized by former employee. I need this program to research the thousands of permits to determine whether the piles of documents are in the system or not. Since she also embezzled thousands of dollars I have to take it upon my self to accomplish the necessary programming. 18 years of trust down the drain.
Bob

[June7]

The code and query look good. The Requery in AfterUpdate event works?

If you want to provide db for analysis, follow instructions at bottom of my post.

Buttons don't show on form in Datasheet view. Can use Continuous view and arrange data controls to look like datasheet. Then toggle between Continuous and Single views. Or maybe the Split form will suit your requirements.

[amerifax]

I thought I deleted the records not needed but they seem to still be in the file,size, and can't be seen. This Access is a result of dbv IV. It was converted File\Open\dBase IV (*.dbf)
It seems to still have a link to the dbf.

Bob
Access 7

[June7]

So you are not providing the db for analysis?

[orange]

What is in this combo [forms]![form1].[myselector] & "*"?
What is the Row source?

Should you be checking against Permit.SeqNo??

I suggest you post a copy for June7.

[amerifax]

Yes but it's 350000 records. Let me take it back to ddBase IV and size it down. About 1/2 hour.
Bob

[amerifax]

Here is file. The 2 image files are not part of this. I just can't delete them from the attachment.
Bob

[amerifax]

"Seal" is what I'm searching on.
Bob

[amerifax]

Some how my permit file got named, novice, to Permit1. I changed it back to Permit. One less issue.
Bob

[June7]

Your form name is [Permit Check], not 'form1'.

Adjust the criteria in the form's RecordSource query appropriately.

[amerifax]

>>June7<<
Your tutorial on Search Box was more than helpful. This is my first form created. I'm porting over from dBase IV. I'm using the form for a very critical project and you made this possible.
Thanks again

Bob