A way better than Dlookup?

S

SF

Hi,

I have a continous form have ProductCode, ProductName, Qty, UnitPrice,
Discount and Sale Amount bound to a temporary table (ADP). Everytime when
user type in the Product Code, I use DLOOKUP to look for other related
information such as ProductName, UnitPrice etc... for the ProductCode
entered from tblProduct.

This work perfectly but dlookup didn't check for the availabilty of the
product in tblProduct. Sometime I got a blank record.
Is there a way to avoid blank record like this.

Regards

SF
 

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

Blank Fields in Report 2
Comination of 3 Combo boxes fills Text box 2
Adding data to Subform and save and running a total price calc 0
Is there a better way? 4
Many to Many junction table and subforms 1
Duplicate Records 1
Access function to calculate FIFO 0
Form question 1

Top