467,092 Members | 1,148 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

VBA Help

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
1 Week Ago #1
  • viewed: 1962
Share:

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@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.