Pulling data

[Khushalay]

I have two different databases. Im successfully pulling data from DB1 into DB2 by this vba code:

Q1 = Nz(DLookup("[q1]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0)
where Q1 is field in DB2 that is automatically filled when DOCKEt field is filled in DB2. It matches the DOCKET field in DB2 with SalesOrderNo in DB1 and pulls the value in q1 into Q1. (This is an integer field)
Im also been successful in pulling string data by the same query.

Now, I have a combobox in DB1 and wanna pull its data into DB2. I applied the same code but it only shows the index of the data and not the actual data.

For example, instead of Oranges, it shows 15 and instead of Apples it shows 10.

What am I doing wrong?

 

[JHB]

I think you just now feel the evil of using Lookup Fields in the table.

 

[Khushalay]

That means Im not the only one.

Any suggestion?

 

[missinglinq]

The Evils of Lookup Fields in Tables

Linq ;0)>

 

[Khushalay]

:banghead:

 

[Frothingslosh]

Yep, sorry to say it, but you're looking at a rewrite on this one if you want to do that.

 

[JHB]

That means Im not the only one.

Any suggestion?

Yes you're not alone!
Create your own lookup table, then you've full control over it.