Data entry form problems 1

[Ctrain]

I am trying to make a data entry form for purchases of products. I have made a combo box for my product number now I need a box that will relate to that box and in the next box display the product name. I am new at this, so I guess I am not quite thinking right. Any help would be appreciated.

 

[KenReay]

Hi

Let us assume that the combo box is based on a table of products, and that you have selected two columns from that table (ie ProductId, ProductDescription), if you set the column width of the second column to zero, then only the Product Number will appear in the combo, you can then place a text box control on the form and set its source to =CboProductId.Column(1)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ctrain]

Thanks Ken! You have really helped that problem. I wish I could borrow you for a couple of days. I would have this whole thing up and going.

I guess I am going to have to go back to my books. Is there any book that you would recommend that could help me, I am trying to swith from Approach to Access. I really like the possibilities that access has.

Have a good one!

 

[KenReay]

Hi

My favourite book is Access Developers Handbook, nice blend of code examples and principles of how and why to do things a certain way. (Soapbox) in my view too many new Access developers get hung up on the code, you have to understand database / table design to have a chance of success

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK