Programming a value into a record field

J

john431

Each time the database is opened, the user will confirm their name from a
combo box. This combo box is a two field table named LogOn. The two fields
are LogOnName and LogOnInitials. When the user then enters a record into
Table1, I want the value of LogOnInitials to be included as the value in a
field named Initials in Table1. This would happen for any new records
entered in Table 1 as long as that user is using the database. A new user
would enter records with their initials included with each record added to
Table1.

Any suggestions as to how to program this?

John
 
A

Alex Dybenko

Hi,
build your logon form, when user press ok there - hide this form using:
me.visible=false

so form will stay loaded.
now in your form, where you enter new records, at initials textbox default
value write:

=Forms!frmLogon!LogOnInitials

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
 
Top