Storing the value in another textbox populated from a combo box in a form.

[kevin19]

Hi all
How does one store the value derived from a combo box to another text box in a form?
E.g.
Supplier name is a combo box. The combo box has 2 columns, supplier and supplier ID.the supplier name stores the supplier in its own text box.
When you select the supplier, the supplierID appears in another text box.
I need to store this supplier ID.
The control source is =[suppliername].[column](1)
When I look up the table, the supplier is captured in the supplier name but the supplierID is not captured in the supplier ID field.
Can anyone help?
Thanks.

 

[Mihail]

Post the DB. Access 2003.

 

[kevin19]

My db is large. How do I post it?

 

[pr2-eugin]

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[kevin19]

Dear Paul
Sorry for the delay as I was off for a little while.
I did what you said and the file size is still 2.77mb after zipping it.
What can I do? I did compact and repair the db prior to compressing the file.
Thanks for helping out!

 

[bob fitz]

Did you carry out Step 4 as suggested by Paul in post #4

 

[kevin19]

Dear Paul

Finally manage to do it.
Kindly find attached file as per your request.
Thanks a lot!

 

[bob fitz]

Can you post a version in A2003 mdb format.

 

[kevin19]

Thanks bob
As you can notice, I managed to upload it.
Regards.

 

[bob fitz]

Thanks bob
As you can notice, I managed to upload it.
Regards.

Yes I saw that you had uploaded it, but I am unable to open versions older than 2003 which is why I asked if you could post a copy in A2003 mdb format.

 

[kevin19]

Dear Bob
Kindly find attached file in your requested format.
Thanks.

 

[bob fitz]

Dear Bob
Kindly find attached file in your requested format.
Thanks.

Thank you. I will take a look at it shortly. We're just about to have dinner.

 

[kevin19]

Thanks Bob!

 

[bob fitz]

Kevin
Can you explain a little more of what you are trying to do. What is the purpose of the two tables. They don't seem to have any relationship to each other.

 

[kevin19]

Thanks for your prompt response.
If you noticed on the suppliers invoice form, the values from the supplier name combo box is by selecting from the supplier account ref table.
When you select the supplier name from the combo box, it will automatically push the supacref value to the supacref textbox by using the following listed below.
The control source of the supacref textbox is =[suppliername].[column](2)
I need to store this supacref in the supacref table.
I hope I am making myself clear.
I try different options but to no avail.
Thanks.

 

[bob fitz]

I need to store this supacref in the supacref table.

Perhaps I'm missing something but I can't see a table called supacref

 

[Mihail]

And this, seems to break the normalization.
Database Normalization and Table Structures - Microsoft Access / VBA

 

[Dhamdard]

If I understand you correctly, when you select a value in the combo box, the supplier ID is automatically shown in another text box. Make sure that the tex box is not an unbound text column.

 

[kevin19]

Hi Bob
Been having a really hectic day. Silly billy me! It is the SupplierAcRef table. I just checked. It is in the db.
Should you seek further clarification, kindly post it.
Thanks.

 

[kevin19]

Hi Bob!
Is it not possible to store the value if there is no relationship between the 2 tables? How should it be done in my case?
Kindly advise. Thanks.