I am having trouble with the code for the following task
Table: Master List
Form: Home
Form: Details

I am trying to get a button on 'Home' that will search a field in 'Master
List' called ID for a value that I input in a text box on 'Home' and return
that record in the form 'Details' for editting.

Please HELP

Is Details a subform of Home?
If not, is Details already open or does it open from the button?
Is Master List the row source for the Details form?

If you can answer these questions, I can show you how it is done.
--
Dave Hargis, Microsoft Access MVP


"Nate" wrote:

> I am having trouble with the code for the following task
> Table: Master List
> Form: Home
> Form: Details
>
> I am trying to get a button on 'Home' that will search a field in 'Master
> List' called ID for a value that I input in a text box on 'Home' and return
> that record in the form 'Details' for editting.
>
> Please HELP

Thanks a ton......

Details is a seperate form from Home. Details is not already open and
Master list is the row source for Details.

Thanks again,


"Klatuu" wrote:

> Is Details a subform of Home?
> If not, is Details already open or does it open from the button?
> Is Master List the row source for the Details form?
>
> If you can answer these questions, I can show you how it is done.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Nate" wrote:
>
> > I am having trouble with the code for the following task
> > Table: Master List
> > Form: Home
> > Form: Details
> >
> > I am trying to get a button on 'Home' that will search a field in 'Master
> > List' called ID for a value that I input in a text box on 'Home' and return
> > that record in the form 'Details' for editting.
> >
> > Please HELP