If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text value of last record
I am tracking site hazard inspection reports, multiple items are turned in by
the same inspector and the same inspection support group. I would like to add new form records (specific hazards) and have the inspector and support group fields populate based on the last date enter to minimize key strokes. The information that was last enter would populate in the new record fields with edits allowable. Once edits were made, this would become the last record information and would update new records. -- kuslusr1 |
#2
|
|||
|
|||
Text value of last record
If you're talking about entering a series of new records and having the
inspector and support group from one record carry forward to the next group, you can use the AfterUpdate event of the control holding your data to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new record. The syntax is slightly different, depending on the datatype of the data: For Text fields Private Sub YourTextControlName_AfterUpdate() If Not IsNull(Me.YourTextControlName.Value) Then YourTextControlName.DefaultValue = """" & Me.YourTextControlName.Value & """" End If End Sub For Numeric fields Private Sub YourNumericControlName_AfterUpdate() If Not IsNull(Me.YourNumericControlName.Value) Then YourNumericControlName.DefaultValue = Me.YourNumericControlName.Value End If End Sub For Date fields Private Sub YourDateControlName_AfterUpdate() If Not IsNull(Me.YourDateControlName.Value) Then YourDateControlName.DefaultValue ="#" & Me.YourDateControlName & "#" End If End Sub If you're talking about having these fields carry forward with the form being closed then re-opened netween records, that a little more complicated. If this is the case post back. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
Thread Tools | |
Display Modes | |
|
|