Recent content by jhazard

Pat, I realise you said that before and it sounds perfect but i don't know how to execute it. Do you have a code example? If I put the code in the before update event of the subform it is ignored and a new record is created after the mainform validation is performed. I'm a bit of a novice at...

No, I don't want to do that. Oh well back to the drawing board :-)

I just need to check that a couple of fields on my main form are filled out and a couple on my subform are filled out. Thats it.

Not sure that helps me much as if I'm correct it relies on the user having typed in a particular box. I need my text boxes to be validated when a record is about to be added. Have I misunderstood? Any other suggestions anyone, this is driving me crazy, I refuse to think it can be this hard!

I have put this code in my subform: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me![CustomerName]) Then MsgBox ("You must fill out a customer name!") Me!CustomerName.SetFocus End If End Sub the validation code in the main form is being fired but this...

Hi there I have a form with a sub form embedded. All I want to do is when the user adds a new record and clicks the navigation bar to validate several fields on the main form and several on the sub form. Can I do it?! Grrrr.... I put all the code in the beforeupdate event of the main form...

OK realised what I was doing wrong (my search form is seperate so I added the combo to that). However adding the combo to my subform now gives me that option. I followed the instructions through and I now have a combo that looks up customername for me but when i select one nothing happens...

Hi My contact table does have the companyid as the foreign. I followed your instructions to put a combo on using the wizard but I dont get the option 'find a record' - the first screen i get is asking me if i want the combo to look up the values or have them typed in. I'm using access 2000...

I have a form based on a table (tblCompanyName) with a subform embedded in it based on another table (tblContacts). When the user clicks my search button they can search on criteria based on tblCompany name and the result is fine, my subform displays related data. However, if the user...