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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter Problem

Status
Not open for further replies.

ZOR

Technical User
Jan 30, 2002
2,963
GB
I am sure I have done this in the past with no problem. I have a form (Form1) and a subform (Form2). They are bound to related tables. On form 1 I have a listbox (List24), which has rowsource query, the list sets the underlying form to the selected record when clicked. All okay so far. However Form2 (Subform) has a listbox, rowsource query, with the ID field criteria being bound to Form1 List24. It should show all records related to that ID. However the parameter for the field keeps getting asked for by a dialgue box, its driving me up the wall. The parameter inside the query of List2 on the subform is =Forms!Form1.List24
Done it so many times before I am sure. Thanks
 
Howdy ZOR . . .
ZOR said:
[blue]However the parameter for the field keeps getting asked for by a dialgue box.[/blue]
Is the query setup to ask for this?

If you post the RowSource of List24 & that of the subform . . . many more will come on boared!

It could simply be a matter of referencing! . . . don't know yet.

[blue]Your Thoughts? . . .[/blue]

Calvin.gif
See Ya! . . . . . .
 
I agree implicitly, with AceMan!

But i'll take a premptive stab, in the meantime.

Sometimes, listboxes are highlighted, and yet they
don't actually have a value.
When you change records, list24 may be loosing it's value.
(at least I had a multiselect, which did that too me??)

Use a MsgBox, aND SEE what value List24 is giving,
after you move to the selected record.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top