Setting a value of a label

[Caleb]

hey,
A few questions here:

1) I want to take a field from a table, and set a label.caption to it.

DLookUp("[Librarian_Name]","tbl_Librarian","[Librarian_User]=Forms![frm_Login]![txtUser] AND [Librarian_Pass]=Forms![frm_Login]![txtPassword]")

That fails

How else can i do it? (not using a query)

2) if i have a label that contains a date that was set using Date(), can i use the value from that label in an INSERT statement and insert it to a field whose type is Time/Date ??

3) Same as above but for time

That's all for now, THANK YOU VERY MUCH

 

[FoFa]

use macro SETVALUE, specify the label.caption and reference your field (no equal sign I think).