After requering a listbox, it blanks along with other controls

N

Nick Mirro

Hello. I need a listbox in a subform to refresh when new data becomes
available. (by combo in same subform). If I force the listbox to requery
using "form current" or the combo's "afterupdate," the listbox becomes
blank, along with all other controls in the subform.


The listbox is populated using this sql:

SELECT qryAllReasons.Reason, qryAllReasons.ContactID,
qryAllReasons.ContactReasonID

FROM qryAllReasons

WHERE
(((qryAllReasons.ContactID)=[Forms]![frmDataExchange]![sbfrmContactInfo].[Fo
rm]![sbfrmContactReason].[Form]![ContactID]));


I'd greatly appreciate help understanding what might be causing the subform
data to disappear and how I can make this work.

Nick
Dallas, TX
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help! Unbound controls cause listbox to requery?? 0
Troublesome listbox 1
How? Form/subform with a listbox to choose child data to display. 2
Using a listbox in a subform 14
Accessing data in a large table 11
Refreshing a combo box with values entered in another tabbed subfo 0

Top