473,320 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Inserting a value into a table from a combo box

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
2 1823
skeata
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
14,534 Expert Mod 8TB
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

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

Similar topics

16
by: cwizard | last post by:
I'm calling on a function from within this form, and there are values set but every time it gets called I get slammed with a run time error... document.frmKitAmount.txtTotalKitValue is null or not...
2
by: Terry Bickle | last post by:
Please forgive me for using the wrong term here or there. I'm an old Excel 4 macro guy who didn't convert to VB and I'm tinkering with an Access 2000 DB. I'm sure there is a simple Access 101...
3
by: Art at ABE Computer Consultants | last post by:
I'm missing something really simple, I'm sure. I have a form to be filled in. The operator choosed a plant species (the botanical name) from a list in a combo box. (The lookup table is populated...
8
by: Lyn | last post by:
Hi, Can anyone tell me how the initial value displayed in Combo Box is determined when a form is opened? I am loading the dropdown from one field ("CategoryName") of a table, with "ORDER BY ". ...
0
by: JSantora | last post by:
Essentially, InsertAT is broken! For the past couple of hours, I've been getting this "Parameter name: '-2147483550' is not a valid value for 'index'." error. Apparently, its caused by having...
0
by: northshore | last post by:
Hello, I am creating a windows application database. I have a primary table 'Individuals' and a lookup table 'Prefixes.' In the Individuals table, I have a column 'PrefixID' that references...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
1
by: =?Utf-8?B?bWZt?= | last post by:
I have recently migrated to VS.Net 2005, and I am struggling to do something very basic with the combo box. I want to manually loop through a data table and add both the display text and the value...
4
by: banderson | last post by:
Hello amazing vba writers, I am trying to make a combo box return a value based on a combo box selection. I have tried a number of the codes posted here and am still having problems. I think it is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.