Pulling values?

[Khushalay]

I asked this question before in this forum but didn't get any answer.

Actually I have two separate databases and the second one pulls few records from the first db using DLookup(). Everything is working fine except the field pulling the record from the combo box. After pulling, the second db shows the index number rather than the original text value.

How to work around this.

Any help would be really appreciated.

Thanks in advance.

 

[sneuberg]

I searched you user name for 0 replies and this is the only post that came up so apparently the first time you asked this question it didn't get posted. In the future I suggest you check to make sure your questions are posted.

I don't understand what you mean by

Everything is working fine except the field pulling the record from the combo box

Please clarify this

After pulling, the second db shows the index number rather than the original text value

What field do you have in the DLookUp?

 

[missinglinq]

And if you want us to troubleshoot your DLookUp code it would probably be a good idea if you posted said code!

If you used the Combobox Wizard to create the cbo, the Access Gnomes have a bad habit of including the Primary Key, even if you didn't include the Field, and making it the Bound Column of the cbo!

Linq ;0)>

 

[Khushalay]

I searched you user name for 0 replies and this is the only post that came up so apparently the first time you asked this question it didn't get posted. In the future I suggest you check to make sure your questions are posted.

I don't understand what you mean by



Please clarify this


What field do you have in the DLookUp?

sneuberg I have been using this forum and getting help since April and have posted some 80 plus posts and replies.

Anyways thats not my concern, my concern at the moment is to get my issue sorted.

 

[Khushalay]

Missinglinq: Here is the code that Im using:
Dim COLOR1, COLOR2, COLOR3, CUSTOMER As String
COLOR1 = Nz(DLookup("[ColorOne]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
COLOR2 = Nz(DLookup("[ColorTwo]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
COLOR3 = Nz(DLookup("[ColorThree]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
CUSTOMER = Nz(DLookup("[CUSTOMER]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
Me.COLOR1 = COLOR1
Me.COLOR2 = COLOR2
Me.COLOR3 = COLOR3
Me.CUSTOMER = CUSTOMER

It works for the colors and the colors are also combo box: The color combo box is not limit to the list whereas CUSTOMER combo box is limit to the list. I hope that is not the reason.