I need to create a simple text box with a search button (1 Viewer)

[Caquibf]

I have a simple database in access and would like to have a form with a simple text box and a search button (referring to 1 field only) "IDT". When I press search, the corresponding registry to the "IDT" field entered should appear.

I need it to find the exact match. Meaning it shouldn´t search everytime I type nor show the narrowing of the search, only the exact one after pressing search. (There is only 1 exact matching field always).

I hope it´s not too pretentious.
I'm attaching the model db.

 

[Isaac]

I don't usually open other people's files, but we should be able to provide precise instructions that you can easily follow.
You can do something as simple as this in the textbox's Exit event:

Me.Recordsource="select * from table where IDT=" & me.TextboxName.Value
Me.Requery

or

Me.Recordsource="select * from table where IDT='" & me.TextboxName.Value & "'"
Me.Requery

(first one if IDT is numeric, second one if IDT is text)

And train your users to type in the box, then hit Tab to exit it.

 

[arnelgp]

i open all, including yours.

 

[Caquibf]

I don't usually open other people's files, but we should be able to provide precise instructions that you can easily follow.
You can do something as simple as this in the textbox's Exit event:

Me.Recordsource="select * from table where IDT=" & me.TextboxName.Value
Me.Requery

or

Me.Recordsource="select * from table where IDT='" & me.TextboxName.Value & "'"
Me.Requery

(first one if IDT is numeric, second one if IDT is text)

And train your users to type in the box, then hit Tab to exit it.

Thanks. I'm trying to get used to code but that was useful!

 

[Caquibf]

i open all, including yours.

Thank you very much! Yes, that´s what I was looking for!

 

[Gasman]

I don't usually open other people's files, but we should be able to provide precise instructions that you can easily follow.
You can do something as simple as this in the textbox's Exit event:

Me.Recordsource="select * from table where IDT=" & me.TextboxName.Value
Me.Requery

or

Me.Recordsource="select * from table where IDT='" & me.TextboxName.Value & "'"
Me.Requery

(first one if IDT is numeric, second one if IDT is text)

And train your users to type in the box, then hit Tab to exit it.

No need for requery if recordsource changed?

 

[Isaac]

Thanks. I'm trying to get used to code but that was useful!

Glad it helped - good luck!

No need for requery if recordsource changed?

I hear that a lot, but don't follow it, personally. I always want to make sure I'm seeing the most recent data, in addition to changing the recordsource, since often the button to change the recordsource is used after also changing data.