Search results

Can anyone help? Thanks in advance.

My column count is 1. I put this now: Private Sub Form_Current() If (Me.cmbDisposition.Value = "Won") Then Me.Parent!btnMoreInfo.Enabled = True Else Me.Parent!btnMoreInfo.Enabled = False End If End Sub The error: Run-time error '2452' The expression you entered has an invalid...

I placed the code in my subform. Here is the complete code: Private Sub Form_Current() If (Me.cmbDisposition.Value = "Won") Then Me.Parent.Parent!btnMoreInfo.Enabled = True Else Me.Parent.Parent!btnMoreInfo.Enabled = False End If End Sub The error reads: Run-time error '2452' The...

Sorry everyone. Today is not my day. How do you say that you want the button enabled? I put Me.Parent!btnMoreInfo.Enabled = True but I doubt that is right....and of course, I tried it and didnt work.

Yes, thanks for the link. Would I use this? Me.Parent.Parent!ControlName I tried that and I dont know what Parent would be....I tried just: Me.Parent.Parent!btnMoreInfo But that didnt work...

The combo box just has text within it. The only choices are "Won" and "Lost". If "Won" than enable btnMoreInfo. If "Lost" or blank then btnMoreInfo is disabled.

I searched Google and this forum for the answer, but I didn't find it. I have a combo box 'cmbDisposition' in a subform 'LeadInformationSubform'. When the user choses "Won" from the combo box, I want a button 'btnMoreInfo' in the mainform 'AllRecordsSearch' to be enabled. If the combo box has...

I got it fixed. Thank you!

Forgot to mention...I did try that as well. I also tried to create a Macro and put in a Where condition but that didnt work.

I know this has been brought up, and I have tried EVERYTHING to solve this problem, but it still wont work. I have tried DoCmd.OpenForm "SalesWon", , , "LeadID = " & Me.LeadID but I might be doing it wrong. I dont know. Open Add/EditRecords And if you go down to the Lead Information section...

You have no clue where I looked to solve this problem. I looked at several websites and several threads on here and I tried several things with my code, but nothing worked. That is why I posted the question. It is just funny that your signature says "Your happy Mailman is always happy to...

And namliam, why do you get upset? I thought these forums are designed to HELP someone who has questions. And I dont want someone to sit all day and help. And you do NOT have to help me if you dont want to, so I dont know why you are complaining. Am I making you sit here and help you? No...

I want the message box to show up ONLY when there are no matches.

That compiled, but the message box show up when there was a match to a search word.

I want to have a message box pop up when there are no results. This is code to search a subform. Take a look at this: http://www.access-programmers.co.uk/forums/showpost.php?p=723424&postcount=13 namliam told me to put this....so I did and I am getting that error.

I am getting an error: Invalid use of property and it is highlighting RS.RecordCount Can anyone help?

I am receiving an error message: Compile error: User-defined type not defined. I am trying to make a message box appear when there are no results. Here is my code: Private Sub btnSearchContacts_Click() Dim strSQL As Variant Dim l_strAnd As String Dim RS As DAO.Recordset Set RS...

And I really do appreciate your patience with this...

One more error: 'User-defined type not defined' and it highlights "RS As DAO.Recordset"

Tried that. It gives me an error message "Compile Error: method or data member not found" I just tried DCount() and it would do the message box, but it would find a match and then display a message box saying there were no matches...