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

Set the combobox default in tab control

547 512MB
I manage to get my code working on the main form when i add a combobox to it, but it is does not set the default value in a tab control for the same combobox, based on a filtered query. I would like to display the combobox on the Tab control by the name of Reports.
main form : orderf
combobox name: subdistrict11
query name: qrysubdistrict
i use form load
Expand|Select|Wrap|Line Numbers
  1. Me.subdistrict11 = Me.subdistrict11.Column(1, 0)
Any suggestions please?
Mar 11 '13 #1
2 1588
Seth Schrock
2,965 Expert 2GB
I'm a little confused by the question. Tab controls don't affect controls like subforms in that you don't have to reference the control through the tabs reference. So are the two combo boxes you mention on the same form or on different forms? If on the same form, they would have to have different names even if they have the same control source. However, your code is basically making the combo box equal to itself. If the combo boxes are on different forms, then you would need the fully qualified reference for the control that isn't on the current form.
Mar 11 '13 #2
neelsfer
547 512MB
Thx for the quick response. I tested the same combobox on both the main and tab control, at different times, to establish what was wrong on the tabbed control part of the form.
I just discovered a silly mistake i made. The bound column in the combobox was set wrong. It is working now. Perhaps somebody else may require this code one day.
Mar 11 '13 #3

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

Similar topics

1
by: Julie Barnet | last post by:
I need to have a combobox functionality (ie. be able to type and/or select from list). I'm using the combobox control from metabuilders.com. For the most part, this control does exactly what I...
7
by: NCrum | last post by:
I want to set the Default value of a Combobox for any changeable record and have got this working but it is totaly unsatisfactory see the code below I loop through the items in the Combo looking...
0
by: Rene | last post by:
For fun, I am developing a combobox control look-alike. The only way that I was able to accomplish creating a dropdown list was to basically show up a form right underneath my custom combobox...
2
by: chris in grimsby | last post by:
I have a combobox of dropdownlist style as one of the controls on a tabbed form. The list is populated by setting the DataSource property to a dataset and then the DisplayMember and ValueMember...
4
by: Ben Coats | last post by:
Hey, I'm trying to find code for an Explorer-style Directory ComboBox. (You know, it display "Desktop", "My Computer", all drives, etc., but it has a treeview control inside the combobox so that...
0
by: yalanue | last post by:
I want to create a combobox with its displaymember populated from a datatable. But once I get it run, the default display member in the combobox is always the first row of the displaymember list....
1
by: andrewbda | last post by:
I have a combo box in a subform that will have different options depending on values in the main form. I would like the combo box to default to the first value in the list. Any help would be...
1
by: =?Utf-8?B?bWljaGFlbCBzb3JlbnM=?= | last post by:
I want to create a customized ComboBox where the methods ComboBox.Items.Add and ComboBox.Items.Insert will behave thusly: -- If the item is not present, add it. -- If the item is present, set the...
0
by: Andrus | last post by:
I use DataGridView containing DataGridViewComboBoxColumn column. Combobox column displays dropdown list opening selection triangle in all rows. This covers part of visible data if columns are...
0
by: piercy | last post by:
Hi, Im tyring to display a dataGridView with comboBoxes on about 5 of the fields. This table is basically permissions to certain parts of my program. In the database i just store a 1 or a 0 (access...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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...

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.