Search results

I'm not sure I follow entirely but I did notice a problem. All my combobox fields are set as text in the table. I should change that to lookup no? As for AnswerID/Answer I see the correlation but I"m not sure how to implement that into VBA.

Me again! Before you ask, I've been reading VBA, VB, Access2010 manuals etc before I post here. I've run into another snag. I have multiple comboboxes on a form with yes, no, not applicable selections. On the referring table they are "text" field types. Once completed it becomes a record in...

Got it! Works great! Thanks!

That's exactly what I need. What is the attached code though so I can use it in my db? Is it a BeforeUpdate event or is it still under the BUttonClick event?

It is only one combobox. It includes "yes" "no" and "not applicable" as selections. Along with multiple others. I want it set up so that if "no" is selected in ANY of the comboboxes then the text in the textbox comes up as No. But if ALL of the comboboxes have either "Yes" or "Not Applicable"...

Sorry, Pain_IniPain, etc are comboboxes, Text67 is the textbox and the code is in the buttons OnClick.

Coding question! Form: Combo1 Yes/No Combo2 Yes/No/Not Applicable Combo3 Yes/No Combo 4 Yes/No Not Applicable Textbox label "Compliance?" Textbox "" If any combobox = No then display "No" in vbRed in Textbox If all comboboxes = Yes or NOt Applicable then display "Yes" in compcolor (predefined...

The "Submit Audit" was set for Add New Record macro. I added a new one called Verify Audit to be pushed prior to submit (will make submit disabled until verify occurs). The verify button contains the code that I previously embedded.

Yup! Adding the new button for verification worked perfectly! Sorry to clutter up the forum with questions I answered myself!

Replaced the DoCmd.CancelEvent with Cancel = True. No change in the error.

K I'll give that a shot before I start adding new buttons. Thanks!

As soon as I posted this a thought occurs. The "Add Record" is a standard macro Add New Record. I'm wondering if I put in another button with the above code and called it verify and then kept the Add Record as the Add New Record macro, it will eliminate this issue.

Having trouble tracking down an error. I have a form, when a textbox or combobox IsNull or "" then label.forecolor = labelcolor (which is declared variable) and setfocus to blank text/combobox when the "Add Record" button is pushed. Code: Private Sub Form_BeforeUpdate(Cancel As Integer)...

Ah! Gotcha! Thanks! :)

Great! Thanks! Um. Where is the forms current event?

Hello all. Here's the layout: Criteria 1: Yes/No/Not Applicable - Enabled Criteria 2: TextBox - Disabled unless Criteria 1 = "No" Code: Private Sub Pain_Elap_AfterUpdate() If Me.Pain_Elap.Text = "No" And Len(Me.Pain_ElapMin & "") = 0 Then MsgBox "Enter total time elapsed if pain is not...

Hey everybody. Having an issue with the text boxes. When testing my form and typing information into the text box, Access appears not to like my using the select all shortcut to highlight existing text, say to delete and correct. Is this a property or event, expression, etc that I need to set...