Search results

oh. Where should I put it? I tried it right after Edit Combo. I tried it after the requery. Which is a repeat, not? I tried it after the whole select thing. Same thing. Same response.

I apparently don't understand the NotInList function. I have several comboboxes so I made a separate module sub called EditCombo to carry out various actions for different kinds of combos and then return to the line "Me.cboPayee = null", etc. Everything works except when the code runs to the End...

GOT IT! "CallingForm = '" & frm.name & "'"). Thank you so much!

can't find the field "Microsoft Access" referred to in your field "CallingForm = '" & frm(name) & "'") = CallingForm = & frmCheck

I'm trying to get an ID from a table and the criteria isn't right. If I use frm.name, it returns "frm.name = "frmCheck". Dim frm as Form From Calling Form: me CallsID = DLookup("CBOCallsID", "tblCBOCalls", "CallingForm =" & frm(name)) This returns name = "Microsoft Access" ---...

Because I don't know the text isn't there until it's been typed in... but I could... what would it save me?

Option Compare Database Option Explicit Public lngInfoXchg As Integer 'ComboBoxUpdate in Access Samples 'frm = This Form (me) 'strCombo = This Combo (cboUserName) 'strItem = the text you typed in the combo 'strDomain = the table or query behind the combo 'strForm = the form used to add to the...

It works! Always so amazing how much I don't know. Thank you both so much!

I've had this code in my samples for a long time and it works great in a form module. Since I'd like to use it in several places I tried to make a module and now I can't get it to work. I can't get past line 10. I think the error may be frm. Is this the proper way to return a form name? ...

Click on Transactions; Then on the Split button. Thank you for any criticisms.

I apologize... I may be overthinking this. I've spent many hours just getting to this point.

If I have Master TransactionID connected to Child TransactionID it doesn't create a new transaction. That's why I have Child = TTransID

Is the form's Control Source query the wrong place to put this?

Maybe I'm not getting you... The subform's Child is TTransID so it automatically gets the mainform ID. The problem I have is the main form does not pick up the subform Child key. I've tried setting it in the query: TTransID: Nz([Me]![subform]![form]![TTransID]) but the form doesn't want to open...

In order to transfer amounts from one account to another I have a subform that's connected Master = TransactionID ; Child = TTransID. So a new record is created with a new fAccountID (combobox). What I can't figure out is how to get the new record ID (orange) into the original TTransID so that...

Thank you.

Good Idea. Thanks.

No, I mean when I click on it after opening the form. When I'm working on various things on the form, move to other records, etc. it works fine. If I click there first, before doing anything else. it errors.

Private Sub Form_Click() Dim bm As Variant Dim rs As Recordset 10 Set rs = Me.Parent.RecordsetClone 'save the bookmark 20 bm = Me.Bookmark 30 With rs 40 .FindFirst "InvoiceID =" & Me.InvoiceID 50 If Not .NoMatch Then 60 Me.Parent.Bookmark =...

Sorry! 1-1 was just a typo. I used 1=1!