Search results

You are correct: typo- sorry I am just testing to see if there is an old value in the field If IsNull(TabCtl0.OldValue) Then

I am trying to test a form value for null- the code below works for text fields, but is not working for a numeric field- it just pops up a message 'you entered an expression that has no value' If IsNull(Me.TabCtl0.Value) Then Help, please? Thanks, Dave

They both appear to work, but on change means there is not yet a value for old value or previous value...

In my post 11 the control is Ctl0 In post 12, which I copied to try, the control name is Ctl10 I will go back tomorrow and try some of the suggestions using the correct name :( I HATE when I do dumb stuff like this! Thanks to all for the help... Dave

I also stumbled across the OldValue command and tried that: Private Sub TabCtl0_Change() If TabCtl10.OldValue = 2 Then MsgBox "You were on page3" End If MsgBox "Option2: Oh Heck" End Sub but it is giving me an object required error...

OK- here is where I am right this minute: Public bHere As Boolean Private Sub TabCtl0_Change() If TabCtl10 = 2 Then 'I'm just guessing here that pageindex of page 3 is 2. Verify. bHere = True MsgBox "Option1: It Works!" Else If bHere Then MsgBox "Option2: Oh Heck" End If End...

I can't figure it out- Here is what I have been working with so far... Private Sub TabCtl0_Change() Dim ctlPrevious As Control Set ctlPrevious = screem.PreviousControl If ctlPrevious.Name = "page3" Then MsgBox "Oh Heck!" End If End Sub Thanks, Dave

You are correct- I was able to locate the OnChange event for the TabControl. I have 4 tabs on my form- The event needed to happen when they left page3 and no other time. Is there a way to limit the event to only leaving that page? Thanks, Dave

There are only four options for tab events- On Click On Double Click On Mouse Down On Mouse Up On Mouse Move There is no OnChange On Enter Thanks, Dave

Tried that- it works ONLY if you click down in the meaty area on the form- not on just the tab. I have combined it with another process, but it is clunky running from there. I am NEVER going to use tabbed forms again- there are just too many work-arounds required. Thanks, Dave

I want to fire a routine when the user leaves a specific tab on my form. Is there an 'On Exit' even for form tabs? Thanks, Dave

Since I own the code I will just add a field that combines the two columns I need as a single field. Then I can just use normal code to use it as a limiter. The code I was trying to use is from a function I wrote to write records out of a pair of combo boxes that the users pair up on a form...

No Change. I did a search on google and learned that it is not possible to reference a combo box in a query- it must be done in VBA.

I am trying to limit returned records in a query to the match on an open form The code below won't run; it is treating the match as a parameter instead of matching the referenced combo box on the open form..... The two fields contained in the combo box are col(0) and col(1) Like...

=DLookUp("[Countofchange?]","[tblSurveyResultsCount]") did the trick. Thanks!

Here is the code that works correctly: =DLookUp("[Countofchange?]","[tblSurveyResultsCount]") Thanks, again, guys :)

Cool- thanks! I will go look at the dlookup function again.

[countofchange?] is a single numeric field in an unrelated table that I am trying to copy to the open form. I am going to give this a try on the VB forum here.

I am trying to fill a numeric field on an open form from an unrelated numeric field in a closed unrelated table. I keep getting an 'Object Required' error. Can you see the problem with this code? Forms![frmOKtoClose?].Text92 = Tables!tblSurveyResultsCount! [CountofChange?] Thanks, Dave

I was asked to include a subform field in an error checking routine for an application that I built a couple years ago. That form is populated by a query from a table. The field they want checked for errors in populated by a different query. There are 5 possible outcomes for that subform. If...