Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One Form to Populate Another

Status
Not open for further replies.

volaris

ISP
Feb 21, 2002
23
US
I have created a form (frmIRAC_Input) with a Combo Box (Combo6), a text box (Text4), and a Continue button. When the Continue button is clicked, it concatenates Combo6 and Text4 (Combo6 & " / " & Text4), closes this form and opens frmSource where I want the concatenated Combo6/Text4 to populate the field SrcNbr (Object = txtSrcNbr) on a new record. Additionally, on the same form (frmSource) I have an Option Group (grpSrcType) that has 5 option buttons. The values for each button is 1 through 5. When the object txtSrcNbr is populated, I also need the Value 1 button to be clicked. I can get it to the form, I just can't populate the two fields. Any suggestions? All help would be greatly appreciated.

Volaris
 
How about on you Command button Click event, where you open the frmSource, you pass the SrcNbr as an argument:

DoCmd.OpenForm "frmSource", , , , , , Me!Combo6 & " / " & Me!Text4

On the Open event of frmSource:

If Me.OpenArgs & "" <> "" Then
Me!txtSrcNbr = Me.OpenArgs
Me!grpSrcType = 1
End If
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top