Using single box and Continuous Form

[perrymans]

I have Tbl_Transaction with the different types of transactions that can occur per report.

Some transaction types could have multiple entries per report, and for them I use a continuous subform.

However, I do have a few fields that are only going to be one value per report, not many.

Because it is only one, I used textboxes and not subforms.

But I don't really know how to do this well.

Do I add the single fields to the main query on the form?

Do I use DLookup?

Any other ideas I am missing?

Thanks. Sean.

 

[Remou]

It would be best to add these fields to the query, if that is possible, however, it may not be, in which case DlookUp may suit.

 

[perrymans]

Can I enter information into a field using a Dlookup? Or only retrieve info?

Thanks. Sean.

 

[Remou]

I am not quite sure what you want. This is a report, isn't it? You can set the control source of a textbox to a DlookUp statement.