Newbie question on field lists 2

[Seafury888]

Lets say I created a report in design view. I did not use the wizard so I have no field lists available to bind to my text fields in my report. So my report has labels, but the corresponding fields that the labels refer to are all unbound. Is it possible to add field lists to my report after its already made, or do I have to start over with the wizard?

P.S I've tried right clicking the text box, going to properties->control source->tables-> and double clicking the field I want, but this gives me an error when I look at the form in preview mode instead of design mode.

Any insight is much appreciated.

 

[stevedi]

Open the report in design view. Open report properties (select black box in the upper left corner. right click). assign a data source (i.e. table or query) to the overall report. The fields in that datasource become the field list for the report.

 

[Seafury888]

Perfect, thats exactly what I needed to know. I didn't realize that little black box was used for anything, looked like asthetics to me. >)

 

[Seafury888]

I ran into another problem, I can change field lists now without a problem, but I can't have field lists from more than 1 table at once...So if I add say, the customer table field list, bind a text box to a field in the customer table. Then switch the field list to the invoice table, the text box bound to the customer table will no longer reference properly....

Any ideas?

 

[PHV]

If you need several joined tables in your report, create a query and assign it as data source for your report.
You can also take a look at the DLookup function.

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