Open Form to Specific Record & pull in data from table to prefill

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

Guest

I have 2 questions.

1. I created a form for my team to enter their monthly status reports. I
want them to be able to go to their respective items. How do I program the
form to open to their first name?

2. When they open the form to create a new item for the status report, is
there a way to have it auto fill in their name by pulling the detail
associated with it in the same table?
 
Yes, see VBA Help for the OpenForm method. There is a Where argument to
allow you to open the form to a specific record.
 

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

Update Two Tables Using One Form Contents 0
Pulling Data from tables to prefill sections of a form 1
Open Specific Record 1
Problem with Report and Forms 2
Read email body and move values to excel sheet 0
Prefill data on a form. 1
Forms: not working right with tables. 4
Pull down box (from table) as criteria for running a query 1

Back
Top