Recent content by THenry

All right! That worked nicely! :D Thanks for all the help on this thread, really appreciate it :D

The textbox is bounded to a field called DateStamp in my table...

Yes, my subform object and name are both called Contact. When I edit the data in Contact subform, the DateStamp is not updated. But when I edit the data in Main form, an error pops up, saying that Access can't find the field 'DateStamp' in my expression. This happens using the below codes...

Pardon me, but I do not get you, how do I check?

Hmmm... no go... field remains empty after editing some data in contact subform... By the way, my codes are: Private Sub Form_BeforeUpdate(Cancel As Integer) Forms!Main!Contact!DateStamp = date End Sub

Oh yes... I have a couple of subforms in fact... Subforms: Contact, Education, Employment, Language, NS, Professional, Reference, Skill My form is called Main actually, not Form, as I said in the previous post.

I'm an amateur in this... do not get what you mean exactly... If my field name is DateStamp and my form is called Form, what's the codes?

Thanks, that worked. But it only works when I edit some data in my main form... Is there anyway to update the date when I edit data in the subforms too?

Hmmm... no go... I've set the default value as Date(), but it does not even show up in the text box. I need the value to be shown in the textbox, as the date where the record was last modified, and automatically inserted into a field in my table. Please help, thanks in advance :)

I have set the default value of my text box to be my current system date by setting its control source as Date(). But I want to enter this date into a field in a table. The problem is, since the control source is already defined as Date(), how can I set the control source to my field's name to...

Thanks dude! That worked nicely :D

The code is stored in the language table, but i need another table to verify which language belongs to which code right? The "LangChart" table does that in my case.

Oops, think I did not phrase myself properly, was too sleepy when post my question :p I want to create a combo box to display the language type from table "LangChart", but upon choosing the language type from the combo box, the value should be entered as "LangCode" into the "Language" table...

Hi people... I have 2 tables, "Language"and "LangChart". The 2 tables and joined by a field called "LangCode" in relationship. "Language" will contain the language abilities of the user, with the fields (LangID, LangCode, Level, SubLevel and ID) "LangChart" is just a chart to verify which...