473,320 Members | 1,982 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.

Value in combo box is changed, all fields in the same form is updated

Hi..i've problems with this update-combo box thigny..

I have a form (CD media details),then in the forms i have 4 types of combo box (CD_Location, Type, Category and Sub_category).
Other availble fields in the form i have Status, CD Title, Language, Date released, Part number, serial number and notes.

the issues here is that..when i click one of the combo box and choose any values..all of the fields in the form is updated/changing
For example, i go to CD_Location combo box n choose CD1-microsoft then the fields updated and shows all of "CD1-microsft" records..
Attached Images
File Type: jpg CD media details.jpg (27.5 KB, 215 views)
Nov 25 '10 #1
4 1468
TheSmileyCoder
2,322 Expert Mod 2GB
Did you make the form yourself?
Whats the combobox's recordsource and controlsource?
Which events are tied to the combobox?
Nov 25 '10 #2
yes.i make the form..
for the CD_Location combo box the record source comes from the table named "tblCDLocation" i extract the data from this table to make the lists.the control source is field combobox CD_Location itself in the current form.

events? what events..? i dont know how to use any events..it needs code right? im very weak in coding..
Nov 25 '10 #3
actually i want it to be like this when i click one of the combo box and choose any values..all of the fields in the form is updated/changing..i dont know how to make it work this way..any suggestions?
Nov 25 '10 #4
@TheSmileyOne
-------------------------------------------------------
yes.i make the form..
for the CD_Location combo box the record source comes from the table named "tblCDLocation" i extract the data from this table to make the lists.the control source is field combobox CD_Location itself in the current form.

events? what events..? i dont know how to use any events..it needs code right? im very weak in coding..

actually i want it to be like this when i click one of the combo box and choose any values..all of the fields in the form will be updated/changing..i dont know how to make it work this way..any suggestions?
Nov 25 '10 #5

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

Similar topics

4
by: Jacob | last post by:
I have a page Add_data.asp which accepts a number of user-entered variables and then inserts them into a database. I have another page, Loc_tree.asp which when accessed, returns a tree of...
4
by: tom | last post by:
Hi Experts, I want to pass the selectedDate value from my calender form to another web form or a web user control. Could you please show me how to do this? Thanks in advance.
3
by: Bundy | last post by:
Hi How do I change the background colour of an input box in a form as soon as the value is changed? Also the background should revert back to it's original colour if the user decides that they...
5
by: David Jia | last post by:
I have a html form in aspx pages, so how can I grant value to the hidden field in this form? For Example: <body> <script language="C#" runat="server"> string strTest = "test"; </script>
3
by: amit75 | last post by:
hi every body. Presently I am using vb.net. Now i am facing a problem that how to convert a string value to vb.net form object
2
by: ToddM326 | last post by:
I have a form (frmReport) with a list box (lstFileName) and a sub form that are not directly related, but I want to be able to store the value from the list box in one of the fields of the sub...
5
by: Rob | last post by:
I have a control (Button) on a Parent form which opens a Windows form... all I want to do is pass a value from the child form back to the parent... it should be so simple... i.e....
2
by: krishnanvarikkath | last post by:
how to pass a value in one windows form to another? is we can use set get properties?
24
by: MNNovice | last post by:
I am trying to display a value from the sub form on to the main form. It's not a calculated data, just plain text. This is what I attempted without success. 1. Created a text box called...
0
by: sarvmardan | last post by:
how to open a report in access containing filtered data using two combo boxes on form and a button to click. let i have two fields and other is . two comboboxes are combo11 and combo9. plz post...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
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...
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...

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.