G
Guest
I have a form(frmDetAccount) with a subform. The Main form's row source
comes from a query which contains emplyoee information. The subform contains
account information whose row source comes from a table. The link between
the 2 tables is employeeID.
I have a table named tblLoan which only contains loan number, date, and a
question(does it require a detailed account information). frmLoan is used to
enter the loan information. If the user says yes, the frmDetAccount is
opened and the employee enters more information about that Account. When
opening the frmDetAccount, the loan number is copied to a field in the
subform.
When I open the frmDetAccount directly, its able to capture only the
accounts I have entered in the database, which is what I want. But when I
use the tblLoan to open the frmDetAccount, the EmployeeID column is left
blank.
So the probably what I should ask is how comes its not detecting me and how
should I take care of that?
The following is the structure of the tables I have:
tblEmployee(EmployeeID, UserID, EmployeeName)
tblDetAccount(DetAccountID, BorrowerName,DetAccountDate, EmployeeID, etc)
tblLoan(LoanID, LoanNumber, EmployeeID,LoanDate)
I have the fosusername() function from the following site,
http://www.mvps.org/access/api/api0008.htm
comes from a query which contains emplyoee information. The subform contains
account information whose row source comes from a table. The link between
the 2 tables is employeeID.
I have a table named tblLoan which only contains loan number, date, and a
question(does it require a detailed account information). frmLoan is used to
enter the loan information. If the user says yes, the frmDetAccount is
opened and the employee enters more information about that Account. When
opening the frmDetAccount, the loan number is copied to a field in the
subform.
When I open the frmDetAccount directly, its able to capture only the
accounts I have entered in the database, which is what I want. But when I
use the tblLoan to open the frmDetAccount, the EmployeeID column is left
blank.
So the probably what I should ask is how comes its not detecting me and how
should I take care of that?
The following is the structure of the tables I have:
tblEmployee(EmployeeID, UserID, EmployeeName)
tblDetAccount(DetAccountID, BorrowerName,DetAccountDate, EmployeeID, etc)
tblLoan(LoanID, LoanNumber, EmployeeID,LoanDate)
I have the fosusername() function from the following site,
http://www.mvps.org/access/api/api0008.htm