Showing specific data

[Nigel]

In A2003 I was able to put a command button on a form that when clicked would
display another form which would contain specific data; i.e. a form of
employees would then disaplay their absences. I built the button through the
wizard and selected the "open form and find specific data to display". This
works fin e in A2003, but when I build it ion A2007, the resulting form
displays all my data, but says it's filtered. Can I see just what I want to
see?

Thanks

 

[Al Campagna]

Nigel,
Since you are opening a new form from another open form, and the
"calling" form has a key value that identifies just that employee
information (ex. EmployeeID). We'll use form names of frmFirst, and
frmAbsences

Use the button's OnClick event to...
(use your own object names, and leave frmFirst Open)

DoCmd.OpenForm "frmAbsences", , , "EmployeeID =
Forms!frmFirst!EmployeeID

This will open the Absences form at the specific Employee you were
viewing on frmFirst.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Nigel]

Thanks for your reply, but why can't I use the wizard to create this as I've
done before?