Search results

JHB I was able to get the filter into a report on click working! That works great. I just do not understand why my real document cannot get it to show right. Meaning whatever my first form does for the "X" the rest follow even if it does not have a "X" in it. What could i possbily be doing...

Also something i do not quite understand is why it will work in a report but not a form.

JHB i am alright with how you set this up (In a way). If you don't mind helping me fine tune in a bit that would be great! I am almost to the end i can see it!!! If i want to filter by report number. How do i get the button to filter it going into the report preview view? Maybe it asks me what...

Here is my sample.The problem im having is in form 1 when i print. You can put a X in the field under the left side chart and the right side will disappear. When you print (The button i have on the form) it will not listen to that X anymore. Sorry the late reply JHP. Thanks again.

JHB This did not work. Anymore ideas?

So I delete the code from the as found/as left after update field? And just have it in the form on current? Because I have the same code in the form current and on load with it in the control after update. So it's on 3 different places. Thank you for having patience with helping me

Still need help with this. If anyone has any ideas please let me know. I am having trouble printing

Private Sub Asfoundasleft_AfterUpdate() If Asfoundasleft = "X" Then Me.Label1141.Visible = False Me.AsLeft0.Visible = False Me.Asleft20.Visible = False Me.Asleft40.Visible = False Me.AsLeft60.Visible = False Me.Asleft80.Visible = False Me.Asleft100.Visible = False Me.Label1138.Visible = False...

I am using a split form so data base on the bottom and form on top. However I have it only printing the form. So each record is its own form in a way. I do not have the exact code right now but it is taking place on the text box on change. The form on current and the form on load. I will try to...

Hey all! I have a question about printing forms. Basically i have a custom form with custom commands such as if statements and such. Everything is great and wonderful until i try and print the forms. For example i have a project # in which i filter my forms under. From that filter i then go into...

Arnelgp thanks for your response. I typed that in but that only works if I have one option in my combo box. How do I use that expression if I have a few options in the combo box? Thanks

Hi all i am trying to get a recall date on my form to auto populate using a combo box. In my combo box i have a "1 year", "6 Month" and "4 Month" options. When i choose one of those i want it to take the current date and add the appropriate time into the recall date field. Here is my code thus...

arnelgp that did not work :(

Ok guys thanks for the help so far. I think what i want to go with is a list box if possible. Is it possible to use if statement to make certain things to appear in a list box?

How would that look in my code?

Not quite. So i have a box that says 29000 Pressure Range. I need another box to auto fill with txt like so. "Today" "Tomorrow" I have my code something like this: Private Sub Pressure_Range_AfterUpdate() If Me.Pressure_Range < 30000 Then Me.Text682 = "Today" Me.Text682 = "Tomorrow"...

Ok so i got some help to write a line of code, but now i need a bit more help. Once again i am very new to coding so if you decide to help try to make it easy! :):) I have a custom form with a box called pressure range. When Pressure Range is above 30,000 i want another box to say something...

I am still stuck if someone else would like to help me!

I guess I do not understand the me.anothercontrol= below. That kind of stuff

JHB thanks for your quick reply. Could you maybe break down the code for me and explain it. I would like to learn and i think that would help!