Recent content by Freeflow

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...

The first column [SM-Man] above is fully poupulated and I'd already checked that there are no empty records.

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...