How do I link 2 forms?

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

Guest

I have 2 forms linked together with stLinkCriteria VBA. The 1st form allows
users to enter their name and it opens the 2nd form and filters for records
with the name they inputted on the 1st form. What I want to do is have the
name entered on the 1st form copied to the name control on the 2nd form for
every new record. The other records on the 2nd form will keep the same name.
I tried =Form![Form1]![Name] for the Name control on the 2nd form but it
doesn't work like I want it to. Does this make sense? Please let me know
what to do. Eventually I would like the DBS to be accessed by a password and
when the user opens a particular form their Name will automatically appear on
the form. Any suggestions how to do that?
 
Not to answer your question, but: what will you do when you get two
users with the exact same name?

It is seldom appropriate to identify records, by person name. You
really need a Person table, where every user has one record, which
includes:
- their name (usually split up into at least two fields: forname,
surname),
- other personal information (eg. their date of birth), and
- a unique identifying code or number.

Then you use that code or number (not their name) in other tables, to
identify that person's records.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Back
Top