I am building a database from four tables. I cannot find a common field between the four to link them. So i could not get them to work as one report. Now i have divided them all up into four seperate reports and want to know if there is a way to have all four print out on one sheet of paper...
Thank you all for your advice. Finally i used the Dlookup to make this work. I built an expression in the code builder with the help of an Access Microsoft representative.
The code goes like this:
Private Sub CODE_LostFocus()
Dim x As Variant
x= DLookup("[LASTNAME]"...
Thank you for replying gcole. But im not sure i understand that. I can put a combobox on the form. And link it to the table with the information. But when i put a number in i want it to automatically bring up their name. Could you explain a little more in depth?
I am trying to find out if in Access, when using a form, if the employee types in a SS# is there a way to automatically enter that persons name information. I am new at Access and working on the 97 version. Any help would be greatly appreciated. Thanx.
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.