Search results

I have a checkbox on a form which when checked runs a macro, however it also runs the macro when I uncheck it. How can I have it so that the macro only runs when checkbox is checked?

i have command button on my form to print the current form. however when i selected it prints all the forms. how do i get it to just print the current form that i am looking at and also print it in landscape only?

i am trying to run a query based on 2 fields one is called REGION and contains records such as NW1,NW2,SE1,SE2, etc. The other is called OFFICE and contains records such as SLA, NON SLA. What i am trying to achieve is to count how many NW records are SLA and how many are NON SLA. I am not...

I have a form with text box for DATE, a combo box for LENGTH OF DEPLOYMENT I.E 4, 6 or 8 weeks and a text box for DUE DATE. how do I get the DUE DATE box to update dependent on the DATE and the LENGTH OF DEPLOYMENT. I have put this statement in the DUE DATE property CONTROL SOURCE =[DEPLOYMENT...

i have a form with 3 text boxes, i would like the user to enters data in box 1 & 2 and then display the result in box 3. However I need to store the result (box 3) in a table and I have read that you shouldn't store calculated fields in a table so what is the best way to go about this?

I have 2 tables as below : table1 TEMP PH4 PH7 PH10 30 4 7 7.9 20 6 8 9 10 7 7 7.9 table2 REC TEMP PH4 PH7 PH10 1 2 3 I also have a form relating to table 2 with a combobox for the temp on table1. how can i get the combobox selection to...