Using filter value to default for new records

[kalulu]

Clinic Visits form is done at 3,6,9,12,15,18 and 24 months. The same table (VISITS) is used repetitively during the study. Timepoint is recorded in the table variable VISMO (visit month). When we browse the form on a particular visit, let's say 6 month ie where vismo=6 we have this problem when we need to create a new record because we want VISMO to default to 6. Likewise we want VISMO to default to 12 when we browse the form where vismo=12. What's the method ?
(a) we created a "Public globalmo as Long" in Module1
(b) on the Form Load we have a statement "globalmo=Me.vismo"
(c) in the Form Preview we have set the default value of vismo as "=(globalmo)"
(d) it doesn't work. Why ? Do we need to do things differently, like saving the loaded value of vismo in a hidden table ?

Alain

[MMcCarthy]

The default value is the value that a record is set to when it is created. It is also loaded with the form and cannot be reset after the form is loaded. However, you can set the value on the new record. If you have a command button to add a new record you can leave the code that assigns Me.vismo to the global variable where it is and put the following code after the new record has focus on the form.

Me.vismo = globalmo

Clinic Visits form is done at 3,6,9,12,15,18 and 24 months. The same table (VISITS) is used repetitively during the study. Timepoint is recorded in the table variable VISMO (visit month). When we browse the form on a particular visit, let's say 6 month ie where vismo=6 we have this problem when we need to create a new record because we want VISMO to default to 6. Likewise we want VISMO to default to 12 when we browse the form where vismo=12. What's the method ?
(a) we created a "Public globalmo as Long" in Module1
(b) on the Form Load we have a statement "globalmo=Me.vismo"
(c) in the Form Preview we have set the default value of vismo as "=(globalmo)"
(d) it doesn't work. Why ? Do we need to do things differently, like saving the loaded value of vismo in a hidden table ?

Alain