Dynamic display of Inner Join data in listbox? 1

[swk003]

I have 2 forms. In the first (logging)I bleep in 50 records and in the second (validation)I re-bleep the same 50 records into a textbox (Photoset_PID) to validate the logging input process.

To avoid missing records out and also to speed up retrieval of these missed records I have placed in the second form (Validation) a listbox (lst_ValidationUnmatchedRecords)
with a Row Source = Query_Unmatched_Logging_data (inner join query)which displays all the unmatched primaryID's of the Logging table (50). Once I start bleeping the records into the validation form, is there anyway of dynamically updating the listbox view without closing the form down. i.e. after each validation record has been bleeped the listbox total should go down?? I presume I need some code in the Photoset_PID_AfterUpdate()????? Can anyone help?

 

[PHV]

Either lst_ValidationUnmatchedRecords.Requery
or lst_ValidationUnmatchedRecords.RowSource = Query_Unmatched_Logging_data

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[swk003]

Thanks PHV

lst_ValidationUnmatchedRecords.Requery works perfectly, I should have known this.

SWK003

 

[swk003]

Hi PHV

The Requery() works fine, however 1 small problem; It only seems to refresh once I have matched the next record in the sequence, therefore at the end of a validation batch it leaves a final record in the listbox, which actually has been matched but is displayed as unmatched.

I initially opted for a button so the user can manually requery() the listbox. This works fine BUT takes the user out of the close form process loop I have coded into the afterUpdate(). Is there a way of using the requery()in realtime???

thanks SWK003

 

[PHV]

In which event did you call the Requery ?
You may try something like this in the Current event procedure of the form:
DoEvents
lst_ValidationUnmatchedRecords.Requery

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[swk003]

Hi PHV

I was originally using afterUpdate() to requery, but the on current event is a much better option as refreshes in realtime. This fits the bill perfectly. Many thanks for all your support.

SWK003