Updating SubForm from ListBox

[Hey_Moe!]

I have subform which uses a SQL statement as the record source.
One of the criteria (ie. Part of the WHERE condition) is a column value from
a ListBox on the MainForm.

Two problems exist:
1. When the MainForm opens, I get a "Enter Parameter Value" window, asking
me to input
the value it should be getting from the ListBox. (I suppose this is fair
enough, as the ListBox hasn't been
created/populated yet!)
2. When the ListBox is there, when I click on a row, I still get the "Enter
Parameter Value" window!
-I'm using a Requery when the row is clicked.
-A MsgBox within the OnClick event, is giving me the value that the SQL
statement should be using!
But the Subform doesn't seem to want to 'see' this value.

Any suggestions?

Thanks.

[Allen Browne]

Instead of referring to the list box in the RowSource of your subform, you
could include the name of the list box in the LinkMasterField s or the
subform control. Then include the name of the matching subform field in the
LinkChildFields property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Hey_Moe!" <mr**@bigpond.c om> wrote in message
news:ci******** *@mws-stat-syd.cdn.telstra .com.au...

I have subform which uses a SQL statement as the record source.
One of the criteria (ie. Part of the WHERE condition) is a column value
from
a ListBox on the MainForm.

Two problems exist:
1. When the MainForm opens, I get a "Enter Parameter Value" window,
asking
me to input
the value it should be getting from the ListBox. (I suppose this is fair
enough, as the ListBox hasn't been
created/populated yet!)
2. When the ListBox is there, when I click on a row, I still get the
"Enter
Parameter Value" window!
-I'm using a Requery when the row is clicked.
-A MsgBox within the OnClick event, is giving me the value that the SQL
statement should be using!
But the Subform doesn't seem to want to 'see' this value.

[Hey_Moe!]

This is what I thought needed to be done, but here's what happens when I try
to use the Link Child & Link Master fields:
"Can't build a link between unbound forms".

I think the cause for this lies in the fact that the ListBox is unbound.
It gets populated in the OnLoad event for the MainForm using
'Me!List13.RowS ource = "qry_Milestone_ Register_04"'
(The database was designed and built by others. I've just recently inherited
it!)

I might need to bind the ListBox without the use of the OnLaod event.

Thanx.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ...

Instead of referring to the list box in the RowSource of your subform, you
could include the name of the list box in the LinkMasterField s or the
subform control. Then include the name of the matching subform field in the LinkChildFields property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Hey_Moe!" <mr**@bigpond.c om> wrote in message
news:ci******** *@mws-stat-syd.cdn.telstra .com.au...

I have subform which uses a SQL statement as the record source.
One of the criteria (ie. Part of the WHERE condition) is a column value
from
a ListBox on the MainForm.

Two problems exist:
1. When the MainForm opens, I get a "Enter Parameter Value" window,
asking
me to input
the value it should be getting from the ListBox. (I suppose this is fair
enough, as the ListBox hasn't been
created/populated yet!)
2. When the ListBox is there, when I click on a row, I still get the
"Enter
Parameter Value" window!
-I'm using a Requery when the row is clicked.
-A MsgBox within the OnClick event, is giving me the value that the SQL
statement should be using!
But the Subform doesn't seem to want to 'see' this value.