Autocomplete a form by selected criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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 :)
 
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
 
Back
Top