Populating text box based on combo box - separate form

[hiwelcome]

Hello all,

The main issue I'm having is trying to populate a text box based on a combo box selection. I've found threads on that - the twist that is throwing me for a loop is that I'm dealing with two different forms.

I have a main/welcome form with two combo boxes on it. Based on the user's selections in these two combo boxes, two different forms are opened for data entry. For instance, box 1 has A, B, C and box 2 has x, y, z. If a user chooses B and z, then form B and form z are opened. What I want is for a text box to be populated on one of the opened forms, not the same (main/welcome) form. In other words, when B and z are chosen, I would like there to be a textbox autofilled with "z" on form z.

My Access knowledge is intermediate at best, so any dumbed down explanations would be appreciated. If there is already a thread addressing this or if I'm posting in the wrong section, my apologies.

 

[Ranman256]

the query that populates the combo can have the path to form1 in it...

where cboBox.rowsource = "qsComboData"

qsComboData=
select * from table where

 = forms!frmMain!cboBox1

(use the BUILDER to get the correct path if needed)

 

[hiwelcome]

Wasn't even using a query to populate the combo boxes but am using one now :banghead:. But still not sure how to proceed off of what you said - can you dumb down (even more)?

Here is the Row Source for the combo box that I want copied to the other form if it helps:
SELECT [SourceXWithinTbl].[XName] FROM SourceXWithinTbl ORDER BY [XName];