Getting a description to display

G

Guest

I have 2 tables:
table1-Customer - with customer_no, customer_descrip, parent_no
table2-Parent - with parent_no, parent_descrip

On my frmCustomer, I'm trying to display the Parent_name. I've tried using
the DLOOKUP("Parent_name", "qryParent", "[customer_no]= "& [customer_no]&"")
where qryParent is selecting:
Customer_no from Customer AND parent_name from Parent
[Forms]![frmContract]![customer_no]

On my form, I get an ERROR and it keeps flashing. I have to do a
ctl+alt+del in order to exit out because it locks up.

What am I doing incorrectly?

Thank you!
gg
 

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

Display the description on the form 2
User interface - add a new customer 8
DLookup Needed? 6
Create new record and then set focus to it in a subform 12
DSUM not working for subdataform 3
Textbox values 2
Can't get subform calculation to display in parent 1
Allen Browne's Return to the same record 1

Top