Showing data on subform from table

V

Valerie Wong

Hi, I have started using Access a week ago and am stuck at the following:

I have created a form with a subform. In the subform, i want to display a
data from a table. I opened the property window and typed in Control Source a
Dlookup formula but the subform would not display the value. it does not show
Name? or Error? but simply blank. what are the possible reasons? and how can
I display the value, either via dlookup or other method?

regards,
Valere
 
V

Valerie Wong

Hi, many thanks for the reply.

I have put the statement in control source or Default value, both give me a
blank output.

=DLookUp("[Public/ Private]","[Company Background]","[Company
Name]=Forms![Company Name]")

The "Forms!" at the end of the statement refers to the subform, right?

Regards,
Valerie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
Creating a Chart on form from selected data in query. 0
Unremovable horizontal scroll bar on subform 1
Adding data from a table to a subform with DLookup 1
Clear the subform 3
DLookup in subform 11
subform total behaving strangely 2
query value subform 3

Top