I have 2 different forms that have synchronized combo boxes (selecting an option in one, changes the options available in the second). The problem is, when I save the record and open the table where the data is going, the field associated with the first combo box is filled with the ID number rather than the text.
I've tried changing the BoundColumn property, but it affects the query/criteria that makes the second combo box function properly.
Appreciate any help on the matter!
5  2238 
Associate the field as follows:
Me.ComboBox.Column(1) ' refers to the second column, 0 is the first
I have 2 different forms that have synchronized combo boxes (selecting an option in one, changes the options available in the second). The problem is, when I save the record and open the table where the data is going, the field associated with the first combo box is filled with the ID number rather than the text.
I've tried changing the BoundColumn property, but it affects the query/criteria that makes the second combo box function properly.
Appreciate any help on the matter!
Associating it like that causes that combo box to not function. It will not let me select any option.
Associate the field as follows:
Me.ComboBox.Column(1) ' refers to the second column, 0 is the first
I meant that you should change the association of the field on the form that the combo box populates not the combo box.
Associating it like that causes that combo box to not function. It will not let me select any option.
Try this. Open the properties for the combobox, and make the following changes:
Column Count: 2
Column Widths: 0", 1"
Bound Column: 1
Just one word of advice tho. If the table where the data is being stored is in any table other than the main table, then the ID is what should be stored and not the text (that is as long as there is another table somewhere that ties that ID to the text). This saves memory space. You should only ever need to access this data via a form, other than for maintenance purposes.
comteck
Yeah, after some struggling yesterday I figured out that I had to play w/ the column counts, widths, and bound column. Thanks for all the help, appreciate it!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: FZ |
last post by:
Hi Gang,
I was wondering if a generous person might be able to walk me
through what I believe is a pretty simple task. I actually have
significant Access experience, but I haven't done it in...
|
by: kathy |
last post by:
Working in a form, I have an Iif statement where if a date is not
filled in, another field will show as a blank. If the date IS filled
in, the 2nd field will show its actual value. The following...
|
by: Abhi |
last post by:
FYI:
This message is for the benefit of MS Access Community. I found that
this prblem has been encounterd by many but there is hardly any place
where a complete solution is posted. So I thought...
|
by: Paolo |
last post by:
Hello,
I have a form based on a query that has four fields (a, b, c and d).
The query get's its data from a table.
The last field of my form is a calculated field (b*c/d). The field d
is not in...
|
by: LSemos |
last post by:
I am trying to lookup phone numbers in a separate table based on the
name in the current Tab control
tblContacts has the fields: Name, Phone, Fax, and Email
In my Form's Tab control, I have...
|
by: Brent Ritchie |
last post by:
Hello,
I want to use check boxes on a form in datasheet form that has a query
for a controlsource. Here is the basics of it:
I created a query that will return all the fields in one table then...
|
by: fonzie |
last post by:
Is it possible to have a data entry form where the information is
stored in several different tables (5 or 6)? I have an inventory
database where Table1 stores all of the data common to all...
|
by: Tom van Stiphout |
last post by:
I want to indicate requiredness by setting the background color of the
control. Ideally I would call a sub in Form_Load to just do its thing.
Below is what I have so far, but I realize this is of...
|
by: RLN |
last post by:
I have 4 queries and all 4 queries use different tables and pull
different columns.
Is it possible to have one Generic all Purpose form (frmGeneral) and on
the fly at run time set frmGeneral's...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
