Recent content by EmergentGuru

ok I put it in the forms box and still get the error and the debug option. Thannks

Private Sub Room_Area_BeforeUpdate(Cancel As Integer) Dim ctl As Control Dim CName As String For Each ctl In Me.Controls If ctl.Tag = "marked" Then If Nz(ctl, "") = "" Then CName = ctl.Controls(0).Caption MsgBox "Following field is required: " & vbCrLf & vbCrLf & CName...

well to test it, I only used the code and tag on one line. When I leave that cell/field it gives me the error message and yes with an option for a debugger button which then opens the sql.

Minty, When I don't put the data in, I then get the error message. The error message allows for "end" or " Debugger". I would prefer for those options not to exist for the end user and all I would really want is a statement saying that this field is required. The only option being to close the...

Do I put that directly in the control before update sql? or do I need to change some of the fields?. Which fields in that language need to be changed on my end. Can you highlight the fields the I need to put in?

On a related not, I put in another Post because I did not want to highjack this post. The new one is below. "Can you make a field required perameters of another field (Possibly by iff statement)" Thanks

Hello, I was wondering if it is possible to "require" a field based on the choosing of 2 choices from another combo box field. For example if the Text "Apple" is chosen in the cbo box, then the dependent date field would become required. Otherwise if the text "orange" is chosen in the cbo box...

It worked and when I leave it blank I get Runtime Error 2467 Is there a way to make a validation text saying that this field must be entered? Thanks

OK Thanks, where do I put the code? do I put it in an event command in the property sheet? Thanks

I assume I am not putting that in verbatim. Assume that the field name is "Apple", what would the code look like? thanks

I got it to work (round about and in a way that Is probably better). I did use the cascading combos/filter by form in the query for the combo. I did not get the specific solution i originally asked for but, I just moved the Main Filter cbo to the subform so both cbos were on the same subform...

Hello, where can you go to make a field in a form a required field. For example you can do it in the table but not in the form. Also, Like when you set validation text for a validation rules, is there an option for setting error text for required fields to make things more user friendly? For...

Your assumption is exactly right. Below is the query that I am using in the combo box to sort/filter. This particular query is separate actual query but based off of a union query (The SQL is below). With that said where would I put the additional SQL that you stated on your previous post...

ok right now I have the dropdown dependent on a query. Where do I find the SQL for the form object. FYI, the dropdown search that I am using is unbound and it auto populates the number in a bound field for the "Inspection Number" when chosen. Where do I go to effect the SQL that you mention...

Thanks, I took your advice and just shut that project down. It would have been useful but not necessary. I am still using the string reference to each item but will accept the fact that the number will increase in aggregate. Thanks for all your help.