unlinked table look up

[DonkeyKong]

This is a stupid question I'm sure, but it may prove helpful to me. I have an unlinked subform on a form. This unlinked subform contains the contents of table: employee. What I want to do is have a textbox that, when typed in, will auto filter out records that don't match what was typed so that once you have correctly typed the employee name all you are left with is records of employees with that name.

I hope that makes sense. Thanks for any help.

 

[rzw0wr]

You might try to make a combo box with the Row Source as;
SELECT ID, LastName, FirstName FROM EmployeeTable ORDER BY LastName;

Bind the forms with ID.

The Main form and the subform will need to have a field ID in them.

For ID, FirstName, LastName and Employee table use your field names and your table name from your table.
Post back if you have problems.
Dale

 

[DonkeyKong]

Thanks for the response Dale. I was able to get the SQL to show the values in the combo box but after that I lost you.

So now my problem is just how to filter for the first value that matches the name I select. Also, the combo box is displaying EMP_FNAME, the employee table is EMPLOYEE and the subform is child59. child59 is where I want to filter the values from. Thanks for your help.

 

[way2bord]

This is actually a surprisingly difficult question to answer comprehensively

I recommend the following solution:
http://allenbrowne.com/appfindasutype.html

 

[DonkeyKong]

Well now that is a neat tool! I don't have time to play with it right now but even if it doesn't fully work I will surely have a future use for that.