If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Don't allow select in combo box
It is an unbound combo box, it'll display the list but when moving the
cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? |
#2
|
|||
|
|||
Don't allow select in combo box
The Locked property may be set to Yes. If that doesn't
solve it, please post the values of the other properties on the Data tab. HTH Kevin Sprinkel -----Original Message----- It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? . |
#3
|
|||
|
|||
Don't allow select in combo box
Is your combo box based on a different table or data that resides in the
same table that the form uses? Did you rename the combo box after setting the link to the table? If so, this will generally break your Lookup and you have to delete the combo box and the code it wrote and recreate. -- G Vaught "Sue-Fong" wrote in message ... It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? |
#4
|
|||
|
|||
Don't allow select in combo box
The properties are as follows:
Row Source Type: Table/Query Row Source: Select [client table].[client name]from [client table]; Column Count: 1 Column Heads: No Column widths: 1.7077" Bound Column: 1 List Rows: 8 List Width: 1.7083" Limit To List: Yes Auto Expand: Yes Visible: Yes Display When: Always Enabled: Yes Locked: Yes Allow AutoCorrect: Yes Tab Stop: Yes Tab Index: 1 Left: 4.2" Top: 0.16" Width: 1.95" Height: 0.25" back Style: Normal Back Color: -2147483643 ..... Blanks on all the Event properties. Help! "Kevin Sprinkel" wrote in message ... The Locked property may be set to Yes. If that doesn't solve it, please post the values of the other properties on the Data tab. HTH Kevin Sprinkel -----Original Message----- It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? . |
#5
|
|||
|
|||
Don't allow select in combo box
Yes, I did modify the Combo box's name and some properties.
I got part of the problem resolved: the main form needs to set the Allow Edits property of Data tab to be Yes, then it'll display your selection in the combo box. The combo box is based on the same table that the form use. Now when I select the value from the list, other fields in the form supposed to show the data from the same record, but they don't. How to make connection between the selection from the combo box and the other fields in the same record of the same table? "GVaught" wrote in message ... Is your combo box based on a different table or data that resides in the same table that the form uses? Did you rename the combo box after setting the link to the table? If so, this will generally break your Lookup and you have to delete the combo box and the code it wrote and recreate. -- G Vaught "Sue-Fong" wrote in message ... It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? |
#6
|
|||
|
|||
Don't allow select in combo box
On Tue, 20 Jul 2004 16:53:14 -0400, SF wrote:
Yes, I did modify the Combo box's name and some properties. I got part of the problem resolved: the main form needs to set the Allow Edits property of Data tab to be Yes, then it'll display your selection in the combo box. The combo box is based on the same table that the form use. Now when I select the value from the list, other fields in the form supposed to show the data from the same record, but they don't. How to make connection between the selection from the combo box and the other fields in the same record of the same table? "GVaught" wrote in message ... Is your combo box based on a different table or data that resides in the same table that the form uses? Did you rename the combo box after setting the link to the table? If so, this will generally break your Lookup and you have to delete the combo box and the code it wrote and recreate. -- G Vaught "Sue-Fong" wrote in message ... It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? According to the property settings you listed in one of your previous messages, your combo box's Locked property is set to Yes. It should be No. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#7
|
|||
|
|||
Don't allow select in combo box
You wrote that it is an unbound combo box. I will assume
this means it is supposed to be unbound. You can populate other fields by adding fields to the query or table that is the combo box's row source. It would have been easier to answer had you given any indication of any details at all about the database, but absent that I will pretend you are selecting a customer name and you want the address, etc. to appear in text boxes elsewhere on the form. I will call the combo box cboCustomerName. You say your combo box is based on a table. If your table fields are CustomerID, CustomerName, CustomerAddress, etc. in that order, set the combo box's Column Count to 3, and the column widths to 0";1.5";0". Set the record source of the address text box to =cboCustomerName.Column(2). Column (2) is actually the third column. The first column (CustomerID in this case) is Column(0). Consider basing the combo box on a query that includes only the necessary fields. If you want to select an entire record based on a combo box selection, use the combo box wizard to get yourself started. -----Original Message----- Yes, I did modify the Combo box's name and some properties. I got part of the problem resolved: the main form needs to set the Allow Edits property of Data tab to be Yes, then it'll display your selection in the combo box. The combo box is based on the same table that the form use. Now when I select the value from the list, other fields in the form supposed to show the data from the same record, but they don't. How to make connection between the selection from the combo box and the other fields in the same record of the same table? "GVaught" wrote in message ... Is your combo box based on a different table or data that resides in the same table that the form uses? Did you rename the combo box after setting the link to the table? If so, this will generally break your Lookup and you have to delete the combo box and the code it wrote and recreate. -- G Vaught "Sue-Fong" wrote in message ... It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? . |
#8
|
|||
|
|||
Don't allow select in combo box
Reset the Locked property to No; this is preventing data
from being entered. Kevin Sprinkel -----Original Message----- The properties are as follows: Row Source Type: Table/Query Row Source: Select [client table].[client name]from [client table]; Column Count: 1 Column Heads: No Column widths: 1.7077" Bound Column: 1 List Rows: 8 List Width: 1.7083" Limit To List: Yes Auto Expand: Yes Visible: Yes Display When: Always Enabled: Yes Locked: Yes Allow AutoCorrect: Yes Tab Stop: Yes Tab Index: 1 Left: 4.2" Top: 0.16" Width: 1.95" Height: 0.25" back Style: Normal Back Color: -2147483643 ..... Blanks on all the Event properties. Help! "Kevin Sprinkel" wrote in message ... The Locked property may be set to Yes. If that doesn't solve it, please post the values of the other properties on the Data tab. HTH Kevin Sprinkel -----Original Message----- It is an unbound combo box, it'll display the list but when moving the cursor to the list and clicking, it won't select. (It is blank in the Control Source property.) Know why? . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot select any value on combo box list | Shawn | Using Forms | 1 | June 22nd, 2004 09:39 PM |
Using Combo Box to Select Date Range | Sahil | Running & Setting Up Queries | 2 | June 16th, 2004 01:22 PM |
Cascading Combo Boxes | Tom | Using Forms | 1 | June 9th, 2004 02:04 AM |
Data Dependencies between Combo Boxes | Tom | Using Forms | 7 | June 6th, 2004 05:25 PM |
Limit content of combo boxes | Tom | Using Forms | 1 | June 5th, 2004 08:44 AM |