Recent content by NeoZakz

I dunno about the above code but I can show you what I put in that finally got it to work in 2000. Form_NEWTracking Public Sub Combo119_Change() If IsNull(Me![Combo119]) Then txtDateDue = DateAdd("d", Me![Seq], Me![txtDateDue]) Else 'if not null txtDateDue = DateAdd("d", Me![Seq]...

Is there a way to save a variable from a Dlookup to a field in the table that is blank maybe? Or can you do a dateadd on a dlookup field?

Hey yea, that should work good. Thanks Ill try it out now. Tell you how it works.

Didnt work But I did find another way around it but ran into another small problem. Can you make a text box and then have an if statement to choose between 2 sets of dates and if one condition is false it takes the other date? Heh, I might be complicating this to much but its a big DB and...

Is there a way in a form to re-run a field event on a refresh command or on load maybe? Ive got a field in detail which loads different letter #'s and some info with them and I want to make a way to refresh it so that when I change something for one thats connected to others it re-runs the...

Better explanation maybe. I tried what you suggested didnt like that. I tried to come up with a better explanation of what Im doing here. Okay here it is, Im using a Form with 2 other subforms inside of it. Im working with the 2 subforms inside and recently I got the code to make them update...

I have a form with 2 sub forms in it. And I just finished the code to update some dates in there. But what Im having trouble with now is that when I change the dates on the form where it pulls the dates from I cant get it to update the other subform that uses them. Anyone got any ideas on how...

I got it working, what I ended up doing was creating an extra hidden text field and had it read off of the Combo119 that way it took only the word in there at the time an stored it here. Then I had the Dlookup read from that box instead it works now just have to figure away to make it...

Could try this instead of the = null I had a similar problem a little while ago. If IsNull(Me!ListItemData(0)) Then That might work for you.

That looks like it might work, but Ill also give that other idea you suggested a try as well. That might actually work easier then what I've been trying to do. Thanks alot!

Objective Oh sorry here let me explain. The code is supposed to check a combo box for a null value and if it has a blank then it does the dateadd by taking the number input into a date change box. If it is not blank its supposed to take the event from the combo box and look up the date that...

I have the following code in VB: Private Sub days_after_AfterUpdate() If IsNull(Me![Combo119]) Then Me![Date Due] = DateAdd("d", Me![Seq], Me![Date Due]) Else DLookup("[Miledate]", "Mile1", Me![Date Due] = Me![Combo119]) = Me![Date Due].Value = DateAdd("d", Me![Seq], Me![Date...