opening a bound form on specific entry

[Guest]

hi all, i have a form bound to a table. from another form, is it possible to
open this form on a specific record?
from a command button on my form bound to tbl:repairs i open my form bound
to tbl:sitereports and default to the site report for that repair job (linked
by an id field common to both tables)
i guess it involves handing a variable to the sitereport form and i cant
find how one can do that.
(i'm not very familiar with access)
any help appreciated,
vauneen

 

[Larry Linson]

hi all, i have a form bound to a table. from another form, is it possible
to
open this form on a specific record?
from a command button on my form bound to tbl:repairs i open my form bound
to tbl:sitereports and default to the site report for that repair job
(linked
by an id field common to both tables)
i guess it involves handing a variable to the sitereport form and i cant
find how one can do that.
(i'm not very familiar with access)
any help appreciated,
vauneen

If you had told us the Field names and the Control names, chances are good
that someone could have given you a specific answer. As it is, please
clarify the name of the Field that is common (in both Tables) and the name
of the Control and Form from which the user will be selecting a particular
one, as well as the Form name you want to open, and, in the meanwhile, use
the Wizard to create a Command Button for Form Operations | Open Form. Then,
if the Properties dialog isn't visible, right-click the Command Button and
choose Properties. On the Properties dialog, click Events, and choose the
Click event, then press the tiny button with three dots. In the code that is
shown, place your cursor on the DoCmd.OpenForm and press F1 -- then look at
the help for the Where Condition argument -- you may not even need to post
back here.

Larry Linson
Microsoft Access MVP