search in form

[meezadahsra]

hi experts....

so i have about six tables with individual forms for each of them. i have used to combo box with lookup wizard to select the employee number in each form so tht the user can enter the details by selecting the emp no. but the problem is that when the emp no is selected , the details entered for that employee are not shown.

i have come to learn tht using a bound combo for searching the employee is wrong,

how else can this be done.

the point here is i want to search the employee with emp no. and also i want to edit the details required. \

also i want to add information for new employees....

my first table will have users add new emp no so tht this is reflected in other forms. ( this was done using bound combo)

 

[Alansidman]

You will probably have to add the table that contains the employee number to your query grid. This is because the bound field in your combo box is what is recorded in the table that you are searching. Link the two tables. Set your criteria in the bound field.