unbound field on a continuous form

[Janet Thomas]

I have a continuous form (as a subform) which displays all the records in tblParts. For each part, I want to lookup the Quantity that may have been ordered (in TblItems) and display it next to the Part in an unbound field on the form. I am doing this using a DLookup at Form_current. Everything is fine except that the Quantity shows the same for every part (the quantity for the first one). If I then click on a part -not the first one - the Quantity on every line changes to that lookup value. Is there some way to do the Lookup for each row?

 

[Dugantrain]

Welcome to the agony of continuous forms. In answer to your question, no, there's really not a way (at least that I've seen) to make an unbound control in continuous forms independent of the other instances of that control. To get around this, I would write a query and add a field in that query which captures the data that you're trying to capture in your unbound control. Use this new field as your form's record source and bind your previously unbound control to that new field.