Repeat value into multiple records

[smorgan@trpd]

I would like to setup a form such that the user enters a location code (BEACH, LAKE, ADMIN etc) once and then complete other fields in multiple. When the records get saved in the database, the location that was entered once will be repeated for each record in the location field.

Top half of form, enter a location

Bottom half is a data grid/table where rapid data entry would take place into multiple fields using a barcode scanner acting as a keyboard emulator. Some example fields in the data grid are: species, quantity, origin.

[June7]

One approach is to use the BeforeUpdate event of a control to set its DefaultValue property to the value just entered. Each new record will then apply that DefaultValue until a different value is entered and then that will become the DefaultValue. Like:

Sub comboboxname_BeforeUpdate(Cancel As Integer)
Me.comboboxname.DefaultValue = Me.comboboxname
End Sub

[Dal Jeanis]

And, put your repeated field(s) on the header and hide them on the detail, with the detail control set to default as June said.