Search results

WhereCondition:="1-1" Works too! What does that even mean? Thank you for your help.

FilterOn=False did the trick! Thank you so much!

It needs to stay open.... I switch between accounts on one form to change the transactions on the other. Same for date. Note the last three lines. Would a requery be required somewhere? I tried one before option 2 but doesn't change the records.

The selection works fine, just the transactions don't change. I wonder if having no WhereCondition assumes the same as first? How do you say "no WhereCondition"?

To keep from dragging things down I have a default of choosing only the current year transactions. If I choose Current year, it works If I choose All, it works If I choose Current year after choosing all, it works I cannot choose All after choosing current year. It just keeps returning current...

If anyone's interested here's what I did. Works! Alias category ID's with a C in front of the ID and Account ID's with an A. Then trim the letter out when you work with it.

Oh neither. I'm just creating a quick expense section for my invoicing. I'm not trying to compete with Intuit but I've been an accountant for years and have used these products so this is the direction my mind goes.

Categories are in one table. Accounts are in one table. Do you want your money to go to an expense category? or to an account (transfer)?

I can but you'll yell at me. Quicken uses categories to do account transfers. For instance, if i take $200 out of checking and pay a bill and keep the rest as cash, $20 is an expense and $180 is an account transfer. The transfer creates another transaction (out of checking, into cash), so no...

I have a combo that picks from one of 2 tables so I use a Union query to combine the choices. However, the primary key on both tables creates duplicate ID's in the bound column of the combo box. How do I know which table is chosen?

the field (control, sorry) has the focus. The blinker's in it. It just doesn't immediately highlight. It's actually a sub sub sub form but it is there.

I just want it highlighted to show it's the focus. Conditional formatting works well for all the fields when entering except that first setfocus. And sometimes it works....??!! Mostly doesn't.

When I Setfocus to a field from vba, the Hasfocus on conditional formatting doesn't consistently kick in. Is there a way to do this differently?

Option Explicit did pick it up. It wouldn't compile. I was blind.

I cannot believe I was so STUPID! I am not a newby! I actually thought I had copied it down because I wanted to check everything before I asked. I thank you so much for your trouble! Going somewhere to die now.

I get what you're saying but you didn't actually change anything from message #6 and I still get "Variable not defined".

The purpose here is to go to sfcInvItem.Description. When adding a new invoice I want items and not receipts.

Will this help...?

Public Sub FormFocus() Dim sf1 As Form Dim sf2 As Form Set sf1 = Me!sfcInvoice.Form Set sf2 = sf1.sfcInvItem sfl.SetFocus sf2.SetFocus sf2.Form!Description.SetFocus same error; same place Although this error (and code) is on the sfcCustDetail, this form is a subform of a main form...

Still same error. sf1 is a subform control and the form in the control has the same name