Single number issue on filtered form?

[Jim001]

Hi all,

I have a form (form2) that filters records based on the employee number (in a combo box) that the user selects. At the moment this works fine on double numbers (such as 10, 12, 80 ect) but if I use single numbers it displays to many records. For example if I select Employee 1 it shows all records that start of with the number 1 such as Employees 1082, 11, 1507, 10043.

If I select Employee 1, I only want it to show records for this employee and the same for other single numbers.

Ive posted the database if any one is willing to have a look for me as its difficult to explain it fully, (ive removed irrelevant tables/forms/reports).Form2 is set to startup, Im using access 97

Any ideas on how I can fix this single number issue?

Thanks

Jim

 

[ansentry]

Have a look at your changed db. Is this what you want to do?

In you second table you did not have a primary key I have put one in and named it TrackingID (AutoNumber - Primary key)


PS I have changed the attachement, I found faults in the other one.

 

[Jim001]

Many thanks ansentry!,

Yes thats just what i wanted it to do, seems quite simple method but works great. I will prob hide the autonumber field (trackID) in the form as the user doesnt really need to see that.


Cheers

Jim

 

[ansentry]

Yes I would leave it there but make is visible=false.

Your code was trying to find a record (Find first etc...) and my is filtering the records to only show the selected "Employee Number"

Good Luck.