Transfer value from previous record

[Stiruchi]

In a multi-user with the FE interface in different PCs, when opening a
form in 'add' mode, is it possible to transfer some of the values
(e.g. name field) from previous record (depending on the user).

Thanks in advance for any help

ST

 

[KARL DEWEY]

One way is to add a bunch of text boxes, set then Visible - No. On button
click 'Add Record' have event/macro set values into the invisible text boxes,
add new record, set the values into form from invisible boxes.

 

[Mike Painter]

I have seen a function that uses Tag to do this but I'm not sure where.
Probably in one of the book's that Getz worked on.

Here is another way,
The most common way to do this is to set the Defalut Value property of the
control to which the field is bound to the current value of the control in
the control's After Update event.

Private Sub txtPartNo_AfterUpdate()

With Me.txtPartNo
..DefaultValue = .Value
End With

 

[Stiruchi]

Thanks for the suggestions but need to send time figuring this out as
I am not that conversant with VBA (sorry).

On another note, wonder if it is possible to get the user's ID from
the PC user or log-in account?

Thanks

ST