Data Entry- how to keep..

[lipin]

I have a form for data entry. A user may enter 100 records under the same rate code. I have an enter command button that adds the records. Each textbox is cleared out so that the next record may be entered. But the "Rate Code" value doesn't change very often so I would like to have that value remain the same and not have a tab stop there so the user can tab around it and only change it when they actually click that textbox with the mouse. So basically, how do I get a value in a textbox to stay the same throughout multiple record entry? Would use default value, but the rate code is different for some users.

 

[Dave Eyley]

Use unbound fields on the form for input.
Give them similar names to those in the Table where you want the data stored.
Allow the user to enter all the info and hit a SAVE button.
The SAVE button starts a bit of code that creates a recordset, verifies the data, if necessary, and then copies all the data to the table.
Then you clear all of the fields except the one you want to keep.

Is that close to what you want?

Dave E

 

[lipin]

Well, I was hoping to somehow set the textbox's default property to = previous records value for that textbox. Is this possible?

If not, I could use the SAVE idea, but I already have an add record button, should I cut that and use the SAVE?

 

[Dave Eyley]

I've seen the method you want elsewhere on the forum. It's not a method I use because it I like all input to be controlled and worked on within strict boundaries.

But have a look at the UNDO command?

Dave E