Unbound txt box + Search Button (1 Viewer)

[THREE05]

Hello World:
I have a unbound search box w a search button.

The purpose of this form is to run from a query that I have
and from there I need to enter the date that the work was done

Like Kind of a LOG OUT form.

but I need help with the programming and if you guys have any advice on wich form would be better to design.. POP UP or SPLIT FORM or wich one?
Im kind a new on this Program so any help would be Forever appreciated..

Thanks.
Three

 

[Ranman256]

I use a regular multi rec form. text box in the header, txtFind
in the AfterUpdate event of the box, turn on the form filter of the form.
ex:
the forms recordsource is qsAllRecords. so you see everything before any search.
enter text in the box press enter:

  sub txtFind_Afterupdate()
    me.filter = "[LastNAme]='" & txtFind & "'"
    me.filterOn = true

to see all records, turn OFF the filter on the toolbar.

 

[THREE05]

I use a regular multi rec form. text box in the header, txtFind
in the AfterUpdate event of the box, turn on the form filter of the form.
ex:
the forms recordsource is qsAllRecords. so you see everything before any search.
enter text in the box press enter:

  sub txtFind_Afterupdate()
    me.filter = "[LastNAme]='" & txtFind & "'"
    me.filterOn = true

to see all records, turn OFF the filter on the toolbar.

Hey buddy thank you very much for your help.. I definitely try it out.