what exactly are you trying to do? look up info in a table based on what is in one of the text boxes? have you tried dlookup? anyhow, write back details if you still need to.
my main problem is: have 11 forms linked by tabs. each form has constituted a table. these tables are related by the relationship.the scenary: when i run the forms, the first employee to be displayed, must display his information on the other forms through that select. in the first form I have the Employee id, the employee Name, the employee identity. when the query is make, i want that through the employee id which is the primary key for all the forms, the information of this employee will appear on the other forms. and so as to other employees.
i hope you understand me. sorry for confusing you.
aqm
so you say the forms are 'linked by tabs'..do you mean that you have a tab control with 11 tabs on it? if so, what is the recordsource of the form that the tab control is embedded in? usually you'd have a big form and it's recordsource is for example tblEmployees. On that form will be a control which has the controlsource of, for example, EmployeeID. then each of the tabs and forms embedded within that form will reference that ID: forms!main!EmployeeID.
will this work? if not please explain more your set up.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.