Combo Box with multiple fields

David Eagar

Registered User.
Local time
Tomorrow, 04:30
Joined
Jul 2, 2007
Messages
924
Have been searching all morning & can't find solution (technique must be haywire)

Have created a combo box query with 3 fields, id-code-description
Objective is to select Code from combo box and populate Description field from the value in the combo box into another table

Have tried all sorts of techniques, none of which have worked

I am sure this has been answered a million times, but I just can't find it

Any help appreciated
 
You can run an Append Query with the Values key word:

INSERT INTO [TableName] ([Description])
VALUES ([Forms]![FormName]![ComboBoxName]);


When the query is run, the value in the combo box's Bound Column will be appended to the Description field of the table.
.
 
Actually, what I'm trying do does not make sense. If I already have the data in one table, why store it in another? Let's kill this thread before Uncle Bob gets me for not normalising my database!
 
Have tried all sorts of techniques, none of which have worked

I thought you were looking for a technique.
.
 
I was, but in this case, my problem was a poorly designed db! The append query approach works but is not applicable to this situation

Thanks anyway for your input
 
Why do you want to store the Description, why not the ID?
 
Why do you want to store the Description, why not the ID?

Ah, you found the fatal flaw in my db design. This is exactly what I needed to be doing. God knows why I set off in the other direction
 
Ah, too busy with the crocodiles that you forgot about draining the swamp. ;)
 

Users who are viewing this thread

Back
Top Bottom