Unmatch query

[bigwillno2]

i created an qrUnmatch query to find the unmatch ModelNumber data between
tblMSM and tblLinkedData
tblMSM has fields ModelNumber, Desc, SpringID, FoamID, ConfigID, SizeID....
etc...this essentially builds a bed.
tblLinkedData has fields ModelNumber, OrderNo, RequiredDate, Comments

frmMSM has controls ModelNumber, Desc, Spring, Foam, Config... etc...and
rowSource = tblMSM
frmBuild has a ListBox that has a rowSource= qrUnMatch and this form also has
a cmdButton.

what i want to do is that the user selects a ModelNumber from the listbox and
click cmdButton, frmMSM should open with the ModelNumber populated to be the
same as the one selected from the listBox.

it's this possible, or it's there a way to build some form that allows the
user to build a bed using the frmMSM, but using data that is not in tblMSM
which is the row source to frmMSM.

[Queezy]

On Mar 23, 5:51 pm, "bigwillno2" <u32748@uwewrote:

i created an qrUnmatch query to find the unmatch ModelNumber data between
tblMSM and tblLinkedData
tblMSM has fields ModelNumber, Desc, SpringID, FoamID, ConfigID, SizeID....
etc...this essentially builds a bed.
tblLinkedData has fields ModelNumber, OrderNo, RequiredDate, Comments

frmMSM has controls ModelNumber, Desc, Spring, Foam, Config... etc...and
rowSource = tblMSM
frmBuild has a ListBox that has a rowSource= qrUnMatch and this form also has
a cmdButton.

what i want to do is that the user selects a ModelNumber from the listbox and
click cmdButton, frmMSM should open with the ModelNumber populated to be the
same as the one selected from the listBox.

it's this possible, or it's there a way to build some form that allows the
user to build a bed using the frmMSM, but using data that is not in tblMSM
which is the row source to frmMSM.

I recreated what I believe is your situation, and I got it to work.
When you created the command button, did you link the listbox, to the
ModelNumber in tblMSM?