Form filter not working

[workuser]

I tried to create a customer filter for my form like the one pbadly suggested on the data pig site but it will not display all the results correctly.



I have two different form filters - frmOne (sorted by Employee Name) and fromTwo (sorted by the EmployeeID)

I believe I exectued it just as instructed and frmOne works accordingly. FrmTwo sorted by the ID, however, acts weird. I have two employees with the same name but different IDs. Apple, A and Bell, B. Both of the names appear in FrmOne which is sorted by name. But when I search for the IDs in FrmTwo access automatically defautls to one of the IDs and does not show both.

For instance - the first Apple, A has Employee ID 00000000 and the second Apple, A has Employee ID 63559590. Likewise the first Bell, B has Employee ID 22222222 and the second Bell, B has Employee ID 58766934.

When I enter 63559590 it automatically defaults to 00000000 the Employee ID of the other Apple, A and when I enter 58766934 it automatically defaults to 22222222 the Employee ID of the other Bell, B.

[pbaldy]

What is it you want to happen? The form is currently displaying both records, as you've requested with the criteria. The ID field is unbound, so it does not change when you change records.

[workuser]

In FrmOne both Apple, As and Bell, Bs appear. I can select either and the other fields will update correctly. In FrmTwo when I select the higher ID of Apple, A or Bell B it automatically changes to the Employee ID that is the smallest in value with the person that has their name.

I set up both of forms the exact same way just switching around the bound columns. I believe both of the combo boxes are unbound. Is there a way to make it bound to switch to the proper result?

[pbaldy]

You didn't address what you want to happen; do you want the specific record displayed or any with matching names? In any case, the combo should be unbound, but the bound column should be the ID field.

[qa12dx]

don't referrence the name. refference the employee id.

in form 2, move ur criteria to under empl ID in form property query. and ur combo properties change "bound column"= 2. (instead of 1)

if u r gonna enter the employee id, may be use a text box instead of a combo box...

ps - cool use of refferencing control in form query. learnt something new