Recent content by boostbyslinky

Morning Paul.. Apologies for not coming back to you last week. With a fresh head I've looked at the issue this morning, created a new form, listbox, query and started re-creating the scenario. I discovered that if I launched the form from the navigation pane the process was fine, however, if...

Cheers Paul.. Just tested it and it still seems to be returning a Null value.. It's failing at listID = Me.List1.Column(0, List1.ItemsSelected) now.. One point to note (whether this is valid, or means anything, I don't know) .. When clicking on a row in the "other" listbox, the row is...

Here we go.. (supplier name changed to ZZZZZ for conf. reasons) Row Type : Table/Query Row Source : SELECT qryCommitmentSummary.ID, qryCommitmentSummary.Type, qryCommitmentSummary.ShortDescription, qryCommitmentSummary.Property, qryCommitmentSummary.TotalContractAmount...

:( ?me.List1 Null

FormA Listbox -> DoubleClick -> Commitment Display/Edit Form (works) FormA "search" button -> FormB -> Select Property or Supplier from Combox box -> Search button -> FormC Listbox Rowsource amended and Form Launched. (this part works!) Private Sub Command5_Click() Dim SQLStr As String SQLStr...

Hello again Paul... It fails @ TCA = DLookup("TotalContractAmount", "tblCommitments", " ID=" & Me!List1 & "") Using the immediates window, ?me!List1 returns Null, whereas if I stick a break point into the "other" listbox and run the same query in immediates, I get the ID of the record I...

Morning.. I have two listboxes, both doing similar things (displaying commitments against properties/suppliers).. The first listbox is a list driven by a query and can be double clicked to launch a display/edit form.. This works without issue. The 2nd listbox within a form which is called...

To answer my own question... Yes.. Set RS = CurrentDb.OpenRecordset(" SELECT tblCommitments.* From tblCommitments Where ID = 42;", dbOpenDynaset) Hurrah! Thanks for your advice. Much appreciated.

I'll mull that one over then.. Uncertain how big this is going to become at this point.. Certainly not 10m, but 10k is conceivable.. As I'm on this voyage of discovery (and feeling a touch lazy), could I select "*" from tblcommitments where ID=42?

Friendly advice always gratefully received.. At what point are we calling the table "big"?

Cheers Mailman.. I've done some reading, googling and testing and come to a method which I think I'm going to adopt.. In simple testing I arrived at this... Sub test() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("tblCommitments", dbOpenDynaset) ID = 42 With rs .FindFirst...

I did wonder whether there was an ordering issue.. I think I've ended up chasing a method which, whilst initially was simple (the append query to add the row to the Archive table), is now not as simple as it could be! So.. Any recommended reading on Option 1? ;) I'll tinker with option 2...

If I wasn't working in a full blown Citrix environment........ :(

The form in question is frmCommitmentEdit Database is attached to this post.. Cheers.

Nope, they're pure and "simple".. ;)