Recent content by whatdoidonext

TomAllins Many many thanks for the explanation. I have managed to get the test working now. Thanks again.

Hi I did post this last week but think I confused everyone! Form 1 has defined a public variable gflag as in integer. The code starts with the on click event of a button on form1 The initial value of gflag is then set to 1. Various tests are performed then on line 25 a second form is opened...

Thanks for the reply, apologies I could not post this earlier. I have made the changes but still cannot get this to work. I will go back to the drawing board and will post again if stuck. Many thanks.

RuralGuy Sorry to have confused you. Form1 does launch Form 2 with DoCmd.openForm "frm_swap_results",,,,,acDialog The static variable dwdA is defined in the code behind Form 1. It is not actually on form 1, it just takes a value from a control in form1 (I won't bore you with why). With Form2...

Rural Guy - thanks for the tip, unfortunately that did not work. When I type in Me in the code for form 1 the drop down does not show the variable WID1 on form 2. It appears that although form 2 is active, the code in the first form cannot see it.

Hi This may well have a simple answer but it eludes me as to what it is. I have one form open from which a second one is shown to the user. This second form is set up with pop up and model set to yes and is opened in code as DoCmd.openForm "frm_swap_results",,,,,acDialog I need to populate...

Many thanks for the response Wayne - it worked a treat. :)

Hi Apologies first if there is an easy answer to this post as I'm new to Access. I have a notes box on a form that users update with the latest progress of work done. At the end of each progress I would like Access to automatically add the date, time and user's network id so that I can track...