Continuous form - won't distinguish between records...

[Steff_DK]

I have a table and a form with continuous records (218 items).
In a different table I have the status of these 218 items.
In design view of the form I have added a label at the end of the record.

I want to use the DMax to set the caption of that label to the status of the particular item, but it sets the status of all 218 items to the status of item 1.
How do I get it to distinguish between the records.

I guess somehow the record source for that label must be changed to the status table after form has loaded, and then run through all records and update the label caption.

How?!?

 

[dt01pqt]

Labels don't have a source that's why they are labels. Use the on current event to update the label txt.

 

[Steff_DK]

Right, so I tried changing the label to a textbox, but problem persists...

The OnCurrent event for what object? The textbox/label?

Thanks!!!

 

[Rich]

You can't use the on current event to change individual captions etc. it'll change them all to the current record's status.
Use an unbound textbox and use DMax as the textbox control source or use query to join the tables, base your form on the query

 

[dt01pqt]

You can't use the on current event to change individual captions etc. it'll change them all to the current record's status.

That exactly what I think she wants.