Recent content by AndreT

Hi, lcook - That was definitely an excellent reference. Appreciate you help. Still my question in the original post was why do the 2 different expressions work? Thanks for your advice.

Sorry, changing my table structures resulting in massive form and event changes. I'm in Windows 7, Access 2007

Sorry, missed one word: when "double click column header DIVIDER", it opened the update form as you prescribed, but not sizing the column heading to fit. I'd like to preserve the sizing option.

Hi, John - Thanks for your quick response. I tried Form_DblClick event and works but ..., if I double click the datasheet column heading, instead automatically expand the column to fit, instead it opened the update form. Any way to prevent that from happening? Appreciate your help.

I want to be able to open an update form when I double click a record in a datasheet (personally I don't like the split form). Do I have to create a double click event for every field? Or is there a shortcut for this one event for all? I tried Form's Detail_Dblclick but it doesn't do...

That was a silly question. Turn out I wasn't in frmMasterSales but in one of its subform. Replacing Me with Me.Parent solved the problem. Still the question, both the following works - Forms!frmMasterSales!sbfUser_Default!chkCustomerContactInvalidDefault...

I have a subform on a form, although these 2 are NOT linked. This expression runs well - Forms!frmMasterSales!sbfUser_Default!chkCustomerContactInvalidDefault=True But both expressions below produce error '2465'-"Master Sales can't find the field 'sbfUser_Default' referred to in your...

Thanks! I'll change all my docmd.Requery to method Requery.

Oh yes, I always use DoCmd.Requery "(controlname)", the (controname) is either a list, combo box, or a datasheet with a list of values based on user selection on the form.

During debugging mode, sometimes the DoCmd.Requery is available, sometimes it's not and produce error 2046 "The command or action 'Requery' isn't available now". Can anyone shed some light on when and why? Thanks for your help in advance.

Wow It works. One of those undocumented features. Thanks for your quick response.

Last time when I close Access, I forgot to clear the breakpoints. When I start Access again, the program break at the points where I set earlier, but no break indicator. "Debug>Clear All Breakpoints" doesn't work. How do I get rid of this pesky behavior? Thanks for your advise in advance.

Due to user requirement, I've changed the organization of one of my form. Some fields originally in the main form are now moved into its subform. Now I found some events should be moved from the main form to the subform. I can handle that. But my question is this - How do I know if any other...

I use control = control.DefaultValue

Re: Tab page Lost Focus Event - Thanks Hi, Bob - Thanks for the advice. Tried it and works just like you said. Except I realized it doesn't work with my philosophy of refreshing other displays real time. Had to send through network to refresh them. Never thought it is controlled somewhere...