Search results

Yes. I added code to current event. Here is the code Private Sub Form_Current() Me.txtbx = Me!Form2.Form!Material Me.Refresh End Sub

Thanks a lot. That link really helped. Record is updating in text box. :) But text box is not updating when I go to new record. :confused: I used Me.Refresh

I've a main form and a sub form. I've a textbox (txtbx) in main form. I want to update value of txtbx with record from subform while I go from one record to next. I found that I've to use "On Current" event. How to code to update txtbx Main form : Form1 Sub form : Form2 I want to update...

Thank you. It worked strSQL = "UPDATE [Support_data2] SET [Start_date] = #" & Format(temp_date, "dd - mm - yyyy") & "#" db.Execute strSQL, dbFailOnError

Hello, I'm struggling with a syntax error in SQL for updating date in a field Dim db As DAO.Database Dim rs As DAO.Recordset Dim GRN_date As Date Dim temp_date As Variant Set db = CurrentDb() Set rs = db.OpenRecordset("PostedGRNfinal") With rs GRN_date = rs!GRN_date temp_date =...

Hi, I'm new to access. I've been using access for last 45 days. I found this forum very helpful.