Opening a second form that shows data related to the first?

[NewShoes]

Hey all,

I am looking at ways to open a second form from an employee main form. I need the second form to display certain data based on the record that is displayed in the first form when the button is clicked.

Example:

If I navigate to customer ref 212 and then click a button to open a second form. I need to the second form to display data only for customer 212. I believe I can do this with OpenArgs but I get confused when the second form needs to use a continours subform?!

Any help is appreciated!

-NS

 

[vbaInet]

This is precisely what you're looking for:

http://baldyweb.com/wherecondition.htm

 

[NewShoes]

This is precisely what you're looking for:

http://baldyweb.com/wherecondition.htm

That's great!

Do you know how I would use this with a continous form? I basically need to be able to update my records everytime a new paper is submitted.

Many thanks,

-NS

 

[vbaInet]

Create a button on your form and add it there. The button will be populated for each record continuously.

 

[NewShoes]

Create a button on your form and add it there. The button will be populated for each record continuously.

Thanks for your reply however, I think I've not made myself clear. The continous form is actually on the second form. I am just a little confisued as to how to make this continous form "see" that i've passed the ref from the main form?

Thanks,

-NS

 

[vbaInet]

If you filter a form the continuous records records will relate to that filter. Apply the WHERE part of the OpenForm method and it will only show records relating to that ID.

 

[debmars]

Check this out Newshoes

I think this is kind of what you are looking for

Cheers
Mars