Passing Info from one form to another

[steve711]

I have a form with several buttons on it that operate very similar to each other.

For instance

Update/New Pilot
Update/New MedCrew
etc.

Each would open a form asking NEW or SEARCH. But instead of having a NEW or SEARCh form for each of these I want one universal one that points the code in the right direction i.e. open the create new pilot form.

I'm a bit lost as where to proceed or how to ask this question in a search on the forum.

Thanks.

 

[KenHigg]

You can pass data using openargs. Would this help?

 

[themurph2000]

I have a form with several buttons on it that operate very similar to each other.

For instance

Update/New Pilot
Update/New MedCrew
etc.

Each would open a form asking NEW or SEARCH. But instead of having a NEW or SEARCh form for each of these I want one universal one that points the code in the right direction i.e. open the create new pilot form.

I'm a bit lost as where to proceed or how to ask this question in a search on the forum.

Thanks.

I'm a little lost as to what you're asking. Do you want a form to open up that shows the record of the Pilot or crew that was just entered on the Update form, or is this a filter? You can have a button on a form open up a query (or a report based on that query) using information typed in that form as the criteria on which to search.

You may want to post a sample of the database with what you're hoping to end up with.

 

[KenHigg]

Here's a link:

http://msdn.microsoft.com/en-us/library/aa160845(office.10).aspx

 

[steve711]

To clarify a bit....

I have an admin form with several options on it....

Update/New Pilot = Update an existing pilot's information or create a new pilot record (name, address, phone #, etc.)

Update/New MedCrew = Same as above but with special identifiers not applicable to a pilot

When those buttons on clicked on a little option form opens with
CREATE NEW = Open the pilot or medcrew form blank (name, address, etc.)

UPDATE EXISTING = Open a search form to look for the guy you wish to update then open the pilot or medcrew form with the existing info to update

What I would love to do is have ONE OPTION FORM open and based on which button either Pilot or Medcrew you used to get to the OPTION FORM it will represent (or point to) the Pilot or Medcrew information.

After reading this again it may cause more confusion. I am a pilot afterall and the English language is not my native tongue (pilot speak is).

Thanks

 

[KenHigg]

Pretty sure you should be able to get the openargs method to work.

 

[boblarson]

And here's a sample if you need it:

http://www.access-programmers.co.uk/forums/showpost.php?p=664411&postcount=17

(from Ken's Db posts)

 

[KenHigg]

Yeah, Like that -

(me<-Duh - Thanks Bob )

 

[steve711]

Have I told you guys that you ROCK. Well you do. As always thanks for sharing your knowledge to us fledgelings...

 

[KenHigg]

Cool - Glad to help -