By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Inserting a value into a table from a combo box

P: 2
Hi, I'm having a major dilemma here. I know it's not very difficult in a sense, but any help will be greatful. So, with no more delay, here is my problem:

I created a form called ImportFiles_AdditionForm. I have a combo box linking to another value in a table. Here is my SQL view:

SELECT dbo_FileTypes.FileTypeID, dbo_FileTypes.TypeDescription
FROM dbo_FileTypes
ORDER BY dbo_FileTypes.TypeDescription;

now, what I'm trying to do is insert the value selected from the combo box into the field on the current table. the table name is dbo_ImportFileFormats and I need it inserted into the field FileTypeID.

Can anyone help me?!? pleeeease! i'm somewhat new to all of this and i am completely lost right now. Thanks in advance!
Jan 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 2
From the reseach that I have been doing, I believe I need to enter some code into the AfterUpdate property. Any suggestions?
Jan 10 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi, I'm having a major dilemma here. I know it's not very difficult in a sense, but any help will be greatful. So, with no more delay, here is my problem:

I created a form called ImportFiles_AdditionForm. I have a combo box linking to another value in a table. Here is my SQL view:

SELECT dbo_FileTypes.FileTypeID, dbo_FileTypes.TypeDescription
FROM dbo_FileTypes
ORDER BY dbo_FileTypes.TypeDescription;

now, what I'm trying to do is insert the value selected from the combo box into the field on the current table. the table name is dbo_ImportFileFormats and I need it inserted into the field FileTypeID.

Can anyone help me?!? pleeeease! i'm somewhat new to all of this and i am completely lost right now. Thanks in advance!
Open the properties window for the combobox and under the data tab set the Control Source property to FileTypeID.

Mary
Jan 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.