Form / Macro Question

[kilosierra71]

Good day all. Looking for some assistance please. I've got a Form created to track work. Pretty basic stuff: Who did the work, What work order# to bill it to, type of work, date done, etc etc. The entry is written to a table. Here's my problem; each time someone launches the Form to enter in a new work order ticket, the form fields, by default, are 'pre-filled' with data from the last entry. So, to prevent folks from over-writing data in the table, i'm looking for a way (Macro perhaps) to force the Form to default to the last row of the table, which is blank.

I'm learning this as I go so the less technical the better.
Thanks in advance.


Kilo

[TheShabz]

Some people like bound forms, but I don't. I don't ever give my users direct write access to my tables. I'd create an unbound form and use an INSERT INTO query to enter in the data then clear out the controls. It will eliminate all your problems.

[RuralGuy]

And I, on the other hand, have only found one situation where and unbound form made any sense; otherwise I always use bound forms. Would setting DataEntry True suit your needs? If not, you can always move to a new record in the OnLoad event of the form.

[rpeare]

are you talking about going to a new record on a subform or a main form?

if it's on a main form you can probably set the ON OPEN property of the form to:

Docmd.gotorecord acdataform, "formname", acnewrec

This might even work in the ON OPEN property of your subform, if it is one, except substitute the subformname for formname.

[kilosierra71]

Thanks all. The simple fix of setting DataEntry to True on the Form properties did the trick. Appreciate all the quick responses.

[RuralGuy]

Great! Glad we could help. So that you know, DataEntry will allow you to *only* see new records that have not been saved yet. As soon as you move to a new record, the previous one is saved and will no longer be visible as long as DataEntry is True.