Autocomplete a form by selected criteria

A

attie

Hi, I am busy working on a Point of Sale system, I am just struggling with
one thing, on my sales form screen (the invoice screen) have all the fields
with a lookup field for the product from a different table. How would I be
able to autocomplete the other fields i.e cost per item from one table based
on the selection from the lookup column from the different table.
 
T

tynerr

I assume that the second, third etc lookups are all conditional on each
other. Just add AND statements to the dlookup function you are using.

Reply with the dlookup() code you have and I'll show you.
 
A

attie

Ive used the wizard to create the form, in the table it was set up as a field
using the Lookup Wizard function. Sorry man, I am very stupid with this :)
 
T

tynerr

attie:

I am also working on a point of sale program. Would you be willing to share
some notes if I run into some problems?

jim at andersonsoftware dot ca
 
Top