469,950 Members | 2,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

VBA Help

1 Bit
I have created an Access 2016 database and need some advice on Primary Keys and a Combo Box.

I think I set my database up wrong by using a Combo Box in a table. I did that so I could select a Retailer name while entering records. Trying to get the Retailer name and not the RetailerID on Forms and Reports, it hasn't been that easy. So, I have decided to start a new database, hopefully, the right way this time. I have imported into a new database the Inventory table and the Retailer table.

With a large Inventory table doing this manually is not an option, it needs some VBA code to transfer the results of the Combo Box to a new Field within the same table. I created a new Field called Supplier. The Table has a Primary Key and is assigned to each record and each record has a Retailer who supplied the Item.

Needed is a way to transfer the Retailer name from the Combo Box to the new text field in the table that is associated with that record. This way I can eliminate the Combo Box and all my headaches and build the database the right way.

Transfer:
Retailer name from Combo Box to new Supplier text Field for each record.

I have learned a lot by watching videos and reading, thus screen name RedEyes.

Thank you
Jan 8 '21 #1
0 2566

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
9 posts views Thread by JJ | last post: by
8 posts views Thread by Mark | last post: by
3 posts views Thread by lord.zoltar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.