Programming a value into a record field

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Need Help Filtering a Form with VBA 2
error trapping 3
Run time error "table opened exclusively" 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Find a record by numbers and letters 3
Access Automatically Send a notification email once a record is added 0
Access Create Access query dynamically 0

Top