Tabbing creates new record, which I don't want
in [Forms]
|
From: gmazza via AccessMonster.com on 6 Nov 2009 12:28 Hey there, I have a form that I enter patient data into. From this form you press a button and it takes you to a final evaluation form, based on the patient from the previous screen. I can enter data into this evaluation form and it saves to the table and life is good. However, when I tab to the next field, and keep tabbing, it eventually blanks out all the fields, as it is allowing me to enter another record. I don't want this. I only want 1 record for that patient. Is this a relationship thing? When I tab, I want it to go through the fields and when its on the last field, go back to the first field. Any help is always appreciated! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
From: Piet Linden on 6 Nov 2009 12:37 On Nov 6, 11:28 am, "gmazza via AccessMonster.com" <u37142(a)uwe> wrote: > Hey there, > I have a form that I enter patient data into. From this form you press a > button and it takes you to a final evaluation form, based on the patient from > the previous screen. > > I can enter data into this evaluation form and it saves to the table and life > is good. > However, when I tab to the next field, and keep tabbing, it eventually blanks > out all the fields, as it is allowing me to enter another record. I don't > want this. I only want 1 record for that patient. > Is this a relationship thing? > When I tab, I want it to go through the fields and when its on the last field, > go back to the first field. > > Any help is always appreciated! > > -- > Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1 Open the form in Design view. On the Other tab (at least in 2003), Change the "Cycle" property from "All Records" to "Current Record". You could add a button to your form to go to a new record if you want (and hotkey it if you like to use just the keyboard).
From: gmazza via AccessMonster.com on 6 Nov 2009 12:39 Sweet, thanks Piet! Piet Linden wrote: >> Hey there, >> I have a form that I enter patient data into. From this form you press a >[quoted text clipped - 14 lines] >> -- >> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1 > >Open the form in Design view. On the Other tab (at least in 2003), >Change the "Cycle" property from "All Records" to "Current Record". >You could add a button to your form to go to a new record if you want >(and hotkey it if you like to use just the keyboard). -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
|
Pages: 1 Prev: DLookUp Issue Next: Populate field based on previous entry |