Form & Table Problem

[rana1978]

Dear Friends,

I have below table and fields in a simple DB

tblinout
FranchiseID (text)
InTime (Date/Time)
OutTime (Date/Time)


frmInOut is developed depending on tblinout. frmInOut has below controls

frnID (control source: tblinout!FranchiseID)
In (it is a DLookUp value)
Out (control source: tblinout!OutTime)
inTime (control source: tblinout!InTime)

Here I am trying to fill [inTime] with the value of [In] after update of [In] using the below code for the field InTime of tblinout

Private Sub In_AfterUpdate()
Me.inTime = Me.In

End Sub


But it is not working.

Could any one help me showing the proper way for this purpose, please?

Rana

 

[namliam]

most likely yuor problem is that "IN" is a reserved word, try doing it like you describe in your post
me.[in]

Tip 1: Dont use reserved words
Tip 2: To prevent accidental use of reserved words stick to the naming conventions, txtIn for example will be much less likely to be a reserved word

 

[rana1978]

Thankx.

But in my main DB I have used another word (like str1 other than reserved), but the result is same.

The problem is table is not updating according to the DlookUp value.

Please other help....