simple?

[sir_dan_mitchell]

Hey people,

I have a really (i think) simple problem. I have a field that contains certain records, when i select a record from this field (its a combo box from a table) I want another field to display the code of the record.

e.g. Dan Mitchell (in first field)
I would then want my NI no. to appear in the field below!

both fields are being looked up from the same table.

Can you help?

Thanks Dan

 

[ColinEssex]

Try a DlookUp in the access help - I reckon that'll fix it.

It'll be something like this

Dlookup("[NINumber]",[TableName],"[YourName] = Form.[ComboName]")

Hope this helps
Col

 

[sir_dan_mitchell]

where would i type this?

 

[ColinEssex]

Hi

Sorry for the delay in responding - been to the pub!!!

Type it in the control source of the field you want the description to show in. The actual syntax is

=Dlookup("[NINumber]","[TableName]","[YourName] = Form.[ComboName]")

you'll need a Me.Refresh on exit of the combo box to fire the DlookUp

Hope it helps

Col