Utilizing multiple forms

[DesignUniv]

Have hit a block and not sure how to alleviate the problem. I am designing a shared database where users would be accessing up to three different forms based on certain criteria. The problem is, I need a way to tie the three different forms together on the back end for reporting purposes. I do not want to have the users enter information in so the forms can tie, such as an ID#. I was hoping to code the forms that when the main form is opened, and then another form is opened, it could copy over let's say a record number to be tied to that item that is being entered. Hope that makes sense.

 

[Peter Reid]

{snip}
Hope that makes sense.

Not to me but then I'm not in the best frame of mind at the moment

 

[DesignUniv]

Clarification to question

Just wanted to clarify this situation a little further. Basically, what I am looking to do is have information from one form carry over to another form while in that record. For instance, I have some customer data on Form 1 that I want to carry over to Form 2 when I select that form from a command button. I am having trouble programming to have that data carry over automatically.

 

[boblarson]

If form 2 is open already, your button on form 1 can just reference the control on form 2:
Forms!YourForm2NameHere.YourTextBoxNameHere = Me.YourTextBoxOnForm1

If form 2 is not already open, you can open it and then reference it.

DoCmd.Open Form "YourForm2NameHere"
Forms!YourForm2NameHere.YourTextBoxNameHere = Me.YourTextBoxOnForm1

 

[DesignUniv]

Thanks a bunch for the reply. This is what I was needing.

 

[boblarson]

Great to hear!