Continuous data entry

[ponneri]

Hello.

I need to create a form that can go on accepting data entry of records until user clicks a stop button.

To say it clearly, first I check if the "Depcode" (field name) already exists in the table through a Dlookup on form. If not, I accept data entry.

In the form, I need to fill in 6 fields per record. Out of these, after first record 4 fields need to show up in next record (repeating) and the remaining two need to accept new values.

This goes on till user clicks a stop button on the form. Split form is not an option in this case, unfortunately.

Does this call for a form/subform or is there any other solution ? How do I proceed ?

I'm concerned because it is just one underlying table.

Please help, anyone ??

 

[pbaldy]

One option:

http://access.mvps.org/access/forms/frm0012.htm

I'd use the after update event of controls rather than a button.

 

[missinglinq]

The method demonstrated in the link Paul gave you is the standard way of addressing this type of thing. Not really sure why you'd need a 'stop' button...when it's time to change the four repeating Fields the user can simply edit those Fields to show the new desired values...or simply close the Form, in which case they'll 'disappear' on their own!

If you insist on having a 'stop' button, simply use it to set the DefaultValue for each of the four Fields to a zero-length string ("".)

Have no idea how Split Forms or Forms/Subforms could possibly apply to this scenario.

Linq ;0)>

 

[arnelgp]

in addition to the two gents suggestions, on the click event of your "stop" button refresh the form, so that all fields are cleaned (blank).

private sub btnStop_Click()
me.controlName.DefaultValue = ""
' other controls do same as above
me.refresh
end sub