silly problem

[varunmathur]

I have a table which I populate thru a form, a few feilds are the same for all records entered together eg date of test(not todays date), course etc is there an easier way to do it than having to enter the same data repeatedly.
varun

 

[Opengrave]

I have a not-so-elegant solution that I use. I created a few text boxes at the top for values that are likely to be the same across several records (date, description, name, etc...). In the actual records section of the form I have an event procedure that updates the value of the field to the value of the field in the corresponding box above. When you have several records that have similar values for all of these fields I enter them in the boxes at the top of the form and then just tab through the fields below, each one automatically populates with the correct valies. For the field in the record that is different from the rest of the records I just type in the value. Here's some (really sloppy) sample code for the event procedures:

Private Sub PCR__Enter()
    Forms![Migration Entry Form]![PCR#] = Forms![Migration Entry Form]![PCR # Parm]
End Sub

Private Sub Programmer_Enter()
    Forms![Migration Entry Form]!Programmer = Forms![Migration Entry Form]![Programmer Parm]
End Sub

Private Sub Short_System_Name_Enter()
    Forms![Migration Entry Form]![Short System Name] = Forms![Migration Entry Form]![System Parm]
End Sub

 

[varunmathur]

Thanks for the help.