On Change Event

[BartK]

Hello all,
I have a question. Here is what I am wanting to do and have been having some trouble trying to get the ball rolling. I initially thought I could do this through a query, however I don't think that is an option. I have attached my Database, keep in mind very early stages.


I have a table with Employee name, number and crew. On my form I have an unbound text box when I type in their employee number I would like for it to filter the results down to that employee number and then pull up the entire record in that table. One problem that I am having with it is it doesn't matter what employee number I type in it will only pull up the first record in the table. Forgot to mention the form I'm having the trouble is on is the update form.

Any help would be greatly appreciated. Thanks.

 

[Mihail]

1) Do not duplicate posts ! You should edited the first one in order to add information.
2) Try to save the DB in a previous version of Access (2003 is the best). using my 2007 I'm not able to open your DB.

 

[JHB]

.. One problem that I am having with it is it doesn't matter what employee number I type in it will only pull up the first record in the table.

Because you have set the wrong references in the filter - the right reference is Me.Text6 and not Me.[Employee Number].
The database with the change is attached.

 

[BartK]

Thank you for that. Sorry it wasn't more challenging for you. Once again thanks.

 

[BartK]

I'm having another little issue. I have created another text box and would like to do the exact same thing that JHB helped me out on. The issue I am having it is not pulling up the information as it did before. This text box is named text 22 and I renamed everything in the module so it should be working or am I missing something simple. The form it is on is the Tracking form, the update form is working well. I will attach a copy of my database again, thanks for all the help.

 

[JHB]

In the property sheet for "Text22" you need to put in "[Event Procedure]" for the "On Change" event, else you code isn't executed.

 

[BartK]

Thank you, I feel stupid now for overlooking something that simple. Thanks

 

[JHB]

You're welcome.
Sometimes (mostly) it helps to take a step "backwards" to clear up your mind, and then look at it again!