Programming a value into a record field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top