Search results

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

I am an Access newbie. I have had some success in using the query wizard to construct simple queries and have done sufficient reading to be able to use a UNION query to provide one answer to my problem. I'm now just checking if there is an alternative answer which would allow me to consolidate...

I'm new to Access too. I found that importing data wasn't too bad. First step is to have a look at the external data tab in Access. This allows you to import data into new or existing tables. I found it easiest to import the speadsheet as a new table and then add the additional columns I...

Thanks for the response. My newbie status to Access probably means I am not making myself clear. The site name is not calculated, it is user defined. Here is an example from my data (Edit Sorry the columns don't line up in the post the same way as the do in the editor) Site-Name...

Typical. I find the solution within minutes of posting. The reason I was asking the question is that I was getting to the point of finding numbers in tables rather than the values (names and addresses) I was expecting. This was happening where I was using a lookup to pull a value from another...

I have two tables that are simple lists of Company name and Company Address. Because these are large companies, multiple names can use the same address (e.g. a holding company with many 'Trading as' names). tblCoName has fields of ID and Long-Name with ID being an autonumber allocated by...