Hi Bob,
Try a Thisform.Refresh after adding your new record. HTH
>Hi, and thanks again for your help in the past. I'm doing a
>form for data entry now, and trying to find out how to prevent
>data from the previous record from appearing in the text fields
>when adding a new record to a file. I've gone to the Tools->
>Options->General page, and Unchecked the box to "Fill new records
>with current values", setting that as a default, but it's not
>having the effect I hoped.
>
>My goal is to have a clean screen for entry of new records
>into a file, as the information is not generally very repetitive
>when adding new records. I only want to do this when adding
>records, otherwise I could blank out the display on the Getfocus()
>event. But I'm trying to use the same form for editing existing
>records and even inquiry if I can get away with it.
>
>I'm sure this information exists somewhere, but I haven't seen
>it yet in the online help or the two books I have, from Que and
>Microsoft().
>
>Thanks again ...
>
> - Bob Longmire
> - Hillside, IL
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.