Open form in edit mode to add contents - but open by user last name

  • Thread starter Thread starter JNariss
  • Start date Start date
J

JNariss

Hello,

I have a database with a table called "Terminations"

I created a form with all the fields from this table.

It is a simple table and form in which a user will go in and enter
information into all the fields of this form when an employee is
terminated. However the person entering this information may not have
all the information to fill up the fields on this form at the time they
initially go in to enter the information.

So.......I would like to give the user the ability to click on my
Switchboard button titled: Complete Termination which as of now opens
up the Termination Form.

I would like to first open a dialog box to prompt the user for "Last
Name" and then click "OK" and that will open only the Forms that
particular "Last Name".

How can I go about doing this?

I know I could just create a query with that table and add the criteria
[Enter Last Name:] but the prolem is that I need to open the form not a
query data sheet.

Any help will be greatly appreciated,
Justine
 
Back
Top