Dlookup Function

T

tarynnl

Im creating a database which has 2 forms called customer details and
invoice i want to beable to lookup the invoice number in customer
details form and if it equals the invoice number in the form invoice to
return the address from the invoice form into the customer details
form.

Invoice number is the primary key in both tables, do the 2 tables have
to be related?

Many thanks
 

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

Sub Total a Sub Table 7
VBA works in orignal but fails in copy of database 1
Set a default sort on a table 1
2910 line of info 13
Form feeding a table problem 1
How do I click on a row on a form and launch new form for that row 9
Adding a lookup list to further filter form results 1
how can i open a report from a subform 4

Top