Search results

Guys as usual thank you all for taking a look. Gasman...your suggestion with the OrderDetails table fixed it. I swear i checked and double checked EVERYTHING except that 😄 arnel...good to know we're still pals 😘

Hi again......i've been working on a small database which has been frustrating the hell out of me. I thought we had it done but now another small issue has popped up. If you look at the order form in the attached file, the Cost txt box in the subform will not display the cents part of the price...

mike60smart....thank you it works great Em x

Hi again everyone......i've attached a database which i've received help with here recently but one more issue has popped up. If you navigate to the Submit A Work Order form and enter your name and selected time, you then go to the subform and select the items you need. All works fine. However...

Nooo....i was joking 😂

arnelgp....honestly is there anything that gets past you ?? Thank you for your help as always Emx

Hi All, I have another question regarding the same database i've been working on.......sorry to keep on asking but they keep coming back looking for silly stuff i can't seem to get to work !. I've attached the file and if you go to the form Submit A Work Order, add your name and a select a...

That's even better again arnelgp...thanks a lot. First thread i ever had where i came out with 2 solutions !. Thanks again everyone for your help with this....i always appreciate it very much. Em x

I think i found a solution. The code below works fine. It goes into the OnEnter event of the subform container Private Sub frm_SubOrders_Enter() If Len(Me.TodaysDate & "") = 0 Then MsgBox "You must select a date.", vbOKOnly, "Select Date" Me.TodaysDate.SetFocus ElseIf Len(Me.cboSelName...

Sorry that's what i meant to write....it's in the AfterUpdate event

Still locked bob...have it in the BeforeUpdate and FormCurrent

Ok i've tried the code below which is supposed to lock the subform until the main form is populated. It does lock the subform but it stays locked even after i fill in the controls on the main form. Can anyone see what i've done wrong ? Private Sub Form_Current() If...

Thanks Minty....how would i disable the subform until there is the correct info in the main form ?

I just gave it a try bob....still lets me jump to the subform with the main form blank. I've just noticed that if i enter a name and then leave the Time blank, it prompts me to enter a time ? If i then enter a Time and go back and remove the name, it will prompt me to enter a name. It's like...

Thanks for the suggestions and advice guys. I think it's probably better if i just attach a stripped down version and let you have a look first hand. arnelgp....i added the code but i still lets me skip to the subform without any message

The main form has the three controls i mentioned in the original post....and the subform just allows the user to add some more detail. It's just that it's no good having the subform details filled out if there is no name and date in the main form. I'm sure it's the correct event as i've used...

Thanks for the suggestion but it still lets me move to the subform without filling in the text box

So how would i change the code if that were the case ?

Thanks arnelgp...i gave it a try but it still lets me move to the subform without any warning messages

Hi All, I have a form which has three controls which must be populated or else the database would be useless. The fields are TodaysDate cboSelName cbo_PickTime I've tried the code below which seemed to work one day and then not work the following day which i found strange ? Can anybody...