Recent content by CVesta81

Hello, I have a form (frmProductsEdit1) and a subform (frmSubPackaging) attached to the form. If any field on the subform changes, I want code to run once the focus is back on the main form that updates the revision date for the specific product code (done by an update query). The code I am...

This is perfect! Thank you so much! I made my code more efficient as well. Thanks!

Also, I apologize for not putting a title on this post. I was too focused on re-reading it prior to sending that I forgot to add a subject line.

Hello, I currently have a table called "tblPictureIndex" that is referenced on my form in Access. I have a button on my form that is meant to clear out two fields in the table based on a field on the form called "CutCode" (also referenced in the same table). My code is listed below: Private...

Perfect! Missinglinq, you were right! I was referencing the field and not the control. The names were very similar, but not identical. I appreciate everyone's help with this!

Me.Parent.RCH_CheckDate.SetFocus

OK, so neither of those worked for me for some reason. I am including the code in the LostFocus for the last control in my subform (Private Sub Notes_LostFocus()). I am getting the message, "Run-time error '438': Object doesn't support this property or method." What am I doing wrong? Do I...

Is it possible to help me with the code? I'm not familiar with setting focus to a parent. This is the code I tried: Forms!frmA1SalesOrders.SetFocus Forms!frmA1SalesOrders!RCH_CheckDate.SetFocus What am I doing wrong?

Hello, I have a main form with a subform in it. The main form's name is frm1ASalesOrders and the subform's name is frmA3SalesOrderDetail. I am trying to program a Lost Focus event so that when the last control in the subform loses its focus, the control RCH_CheckDate gets the focus in the...

I got it to work. My only question is I'm assuming this code doesn't work correctly if I have a continuous form with both Canada and USA in the form. I tried it and it seemed to switch back and forth between formats when I would click on the different records. Anyway around this? If not, I can...

OK, So here is my code. It doesn't appear to be working. What am I doing wrong? Private Sub Form_Current() Me.Country.SetFocus Select Case Country.Text Case "USA" Zip.InputMask = "#####-####" Case "CANADA" Zip.InputMask = "??? ???" End...

I have not. Where would I place such code? Would I use this in the "On Current" part of the form?

Hello, Is it possible to change the input mask of a particular field based on the content of another? My example here is I have a field named, "zipcode" and I would like to change the input mask of that field depending if the country field reads, "USA" or "Canada". As you may or may not know...

Actually, I solved this one onmy own. I used a pass through public variable and then assigned a each table the ID. thanks for your help!

There must be something screwed up with my relationships in my database, because the Master/Child properties are correct. I have all forms set for Data Entry but only the main form shows. As an alternative method, is it possible to run an Append Query when I close the form? I would envision...