from a from to a table

[DirtDawg]

Hello,

Can some one help me with this dilema? I have a form That has a combo box. This combo box look at a table a pulls of the information needed. then I use dlookup in a text field box to fill in the next box automaticly. But when I try and save to record to the main table only the Combo box is being saved. Dlookup is working fine, it is just the saving part.

 

[wizcow]

Hunnicutt

I believe you are saying you want to save the DLookUp field.

Normally you don't need to, as it is already saved somwhere, otherwise your DLookUp wouldn't find it.

If you really need to save it, use a macro in the 'AfterUpdate' of your combo box. Use a 'Set Value' function.

Keep in mind, it is thought to be poor database design to store something that is already stored.
You can use a call function like DLookUp any time you need the value.

Good Luck
Tom