Help - Invoice forms and Product tables

[SD Diamonds]

I am stuck trying to get information to automatically
fill in a form after I enter the ID for a product. I am
working with a template in Access 2000. I may be looking
to hire someone for this because I am at the end of my
rope - but I would be paying out of my own pocket -so
probably not much.
If anyone has any suggestions (I have been unsuccessful
with the dlookup function) I am open to any and all
suggestions!

Katie

 

[Ken Snell]

Why not use a multicolumn combo box instead? and then use a textbox to show
the info to be "filled in".

See this article on The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

If this isn't what you seek, post more info re: what your setup is.