Fosusername()

[Guest]

Yes I did, I put the beforeinsert event on the main form, i.e., frmDetAccount

 

[Douglas J Steele]

But doesn't your problem occur when you branch to the form from somewhere
else? Doesn't that other form insert data as well?

 

[Guest]

You are absolutly right, that the problem occurs when I branch to the form
from a different form - frmLoan. That other form frmLoan copies/pastes the
loan number into frmDetAccounts Subform's loan number with this LOC....
Forms!frmDetAccounts!frmDetAcctSubform!LoanNum = Me!LoanNum

 

[Douglas J. Steele]

Sorry, but I'm running out of ideas.

Since we've been carrying on this thread for sometime, it's unlikely anyone
new will be chiming in. I'd suggest reposting your question, providing as
much information as a summary as you can.

Good luck.

 

[Guest]

Thanks Doug.... You tried to help...
I will repost it again, but maybe there is something that I was missing that
might be of help.... tblLoan is related to only employee table. Employee
table is related to tblDetAccount.
frmLoan data source is from tblLoan....
Is this helpfull?

 

[Douglas J. Steele]

The problem is we seem to be talking at cross-purposes. You have to realize
that by itself, fOSUserName isn't going to do anything for you. You have to
add code to your application to populate the EmployeeID field.

You're the only one who knows your application. So far, I've been unable to
find out from you how you're getting the results of fOSUserName into the
various tables that it needs to be in. It sounds as though you're not
managing to get it populated under some specific condition(s), but I have no
idea what those conditions are.