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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data entry form problems 1
- Thread starter Ctrain
- Start date
-
1
- #2
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 - UK
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 - UK
- Thread starter
- #3
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!
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!
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 - UK
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 - UK
- Status
Similar threads
