Final observation
The combobox is unbound therefore the form load event sets the initial value to avoid the appearance of a blank combobox but data for fields that come from the underlying dataset.
I have tried assigning both number and text during the load event and either is accepted.
The...
:eek:
I have now.
Your suggestion got me most of the way. All is now working as it should.
I think my problem came from how I named things so I was trying to line up the combo box 'cmbMyUnbound' with the field 'myUnbound' in the construction of the query.
I changed that so that I was...
No, column 4 is a number (foreign key)
From
https://msdn.microsoft.com/en-us/library/office/ff822489.aspx
In Visual Basic, set the BoundColumn property by using a number or a numeric expression equal to a value from 0 to the setting of the ColumnCount property.
The leftmost visible column in...
They are both text.
When single stepping through
me.cmbMyUnbound = me.recordset!MyUnbound
With the yellow highlight on the statement then hovering the cursor over each part of the statement shows
me.cmbMyUnbound ->"Hello World"
Me.recordset!MyUnbound ->"A nice reply"
Afterwards, with the...
Requery happens automatically whenever you assign a value to rowsource.
As I said in my post above. Pulling down the combobox shows that the query has run correctly.
I have an unbound combo box on a form.
I assign a query programatically to the combo box row source
The pull down of the combobox shows the query has behaved correctly but the combobox is blank.
The combo box query has 5 columns
The bound column is column 4
All columns in the query are...
I've obviously changed something in the background as I'm getting the following error "The value you entered isn't valid for this field" (80020009).
This is the code
Private Sub Form_Current()
' The assignments below keeps the unbound combo boxes cmbFamily and cmbNameGeneric in line with...
Just an update on this solution. The form data source was a Table. This led to an anomalous behaviour in that the pull down list for the combo box was in alphabetical order BUT the navigation buttons were working on ID number.
This anomalous behaviour was corrected by changing the source of...
That's exactly what is needed.
When the form is first opened after loading the database the first record is shown in the combo box. :)
The combobox tracks the recordset displayed by the navigation buttons. :) :)
Selection using the combobox selects the correct record. The pull down list from...
When you follow the linked to procedure then the resulting combo box is unbound
Control Source is empty
Row Source has a Select statement of the type
SELECT [lstSM-Names].[SM_Man], [lstSM-Names].[Tradename], [lstSM-Names].[SM_PhEur], [lstSM-Names].[PhEurNo] FROM [lstSM-Names];
Row...
[Solved] Combobox as record selector is blank doesn't update with navigation controls
I have a form with a subform (dataset). I have followed this advice
https://...
It's an interesting life isn't it.
Whilst investigating this issue today I tried entering a value not on the lookup query and it was accepted. This value was persistent after closing and reopening the database.
This is the query that provides the lookup I need
SELECT [API-ASMF-List].Version...
In Table 1 the version numbers refers to a certificate issued by a Government Agency. The version numbers have an issue date from which can be calculated the expiry date. This allows the user to contact the manufacturer well in advance of expiry to determine if the certificate will be renewed...
Yes I can see this. The reason they are two separate tables is that table 1 used to contain more information but I moved the extraneous information to a separate table. To consolidate the two tables into one I need to find a way of allowing the user to add the version number from a lookup or...