Populate LoginName of the user! Please Help!


G

Guest

I am not sure why am not getting the right results but this is what is going
on. I have a tblEmplyee that contains The employees names, LAN LoginNames,
contact infor etc. e.g., 1. John Smith LoginName is x112N112 as entered in
the daatabase.

I have 2 other tables
tblLoan=LoanID,LoanNumber,RqdDetailAcct,EmployeeID(fk)
tblDetAccount=DetAcctID, BorrowerName,BorrowerDate,EmployeeID(FK)

using a wizard to create the form and subform for frmDetAccount.
Mainform rowsource I have it as SELECT tblemployee.LoginName, tblemployee.*
FROM
tblemployee WHERE (((tblemployee.LoginName)=fosusername()));
The subform -frmDetAcctSubform rowsource information contains
DetAcctID, BorrowerName,BorrowerDate,EmployeeID (where DetAcctID and
EmployeeID are hidden

frmloan is supposed to open the frmDetAccount and require me to enter more
information about the loan accout information. Whatever information I enter
should be saved under my name.

If Me.RqdDetailAcct.Column(0) = "yes" Then
DoCmd.OpenForm frm, , , , acFormAdd,
Forms!frmDetAccounts!frmDetAcctSubform!LoanNum = Me!LoanNum
 
Ad

Advertisements

R

Robin

Not sure even what the question is? What results *are* you getting and what
did you expect?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fosusername() 25

Top