Shift+Enter not working in popup

Dear experts -
An annoying thing - we have a popup to enter data. Data entry is set to true. It is a single form. We get to the last field - all fields are filled out, we put in a breakpoint at the first line of the beforeupdate - but when pressing Shift+Enter, we don't hit the before update. Just get the pencil icon - any ideas why that would be?
Thanks!
terpsichoreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Is the form bound (has a recordsource)?

Does the OnBeforeUpdate property read "[Event Procedure]"?

When you click the builder button (...) on that property, does it take you to your code?

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
A couple thoughts...

Before update will only execute if you are actually modifying/adding data.  If you haven't made any changes, it won'r run.


Check the Enter Key behavior for the 'last' textbox.  Is it set to 'New Line In Field'?  If so, try "Default" instead.
0
terpsichoreAuthor Commented:
Answers to your questions:
1) I added an OK button, whose code reads "me.dirty = false" - when I click this, it hits the beforeupdate event. The record inserts properly when this fires.
2) There is a recordset - no problem there, I think.
3) The beforeupdate code is linked properly (and, as noted above, is firing properly).
It seems to be something about Shift+Enter - the actual insertion of a record and data checking seem to be working fine... puzzling!
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<3) The beforeupdate code is linked properly (and, as noted above, is firing properly).
It seems to be something about Shift+Enter - the actual insertion of a record and data checking seem to be working fine... puzzling! >>

Do you have:

1. An auto keys macro?

2. The forms Keypreview on and altering keystrokes?

Jim.
0
terpsichoreAuthor Commented:
keypreview says 'no'
there is no auto keys macro that i am aware of - where can I see that?
0
terpsichoreAuthor Commented:
I'm calling the form with this line - not sure if one of these arguments might cause it?
DoCmd.OpenForm "Expense_Lines_Popup", , , , acFormAdd, acDialog
0
terpsichoreAuthor Commented:
I see that the form CALLING THIS ONE has keypreview set to YES - would that matter?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<there is no auto keys macro that i am aware of - where can I see that? >>

 under macros.

<<I see that the form CALLING THIS ONE has keypreview set to YES - would that matter?>>

 No.

Post a DB with the form if you can.

Jim.
0
terpsichoreAuthor Commented:
there are no macros.
When I launch the popup by itself and hit shift+enter, it DOES hit the beforeupdate event!
any idea what else might cause it coming into this form?
I don't think I can feasibly upload the whole system...
0
terpsichoreAuthor Commented:
OK - issue solved -
DoCmd.OpenForm "Expense_Lines_Popup", , , , acFormAdd, acDialog

=> if I remove the arguments, then the shift+enter works! (the form itself has model and popup both set to yes)

Thank you for your input - I will award you the points since your comments were insightful as usual, and also helped point me in the right direction
0
terpsichoreAuthor Commented:
great comments. ultimate solution was in the arguments in the openform command.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<> if I remove the arguments, then the shift+enter works! (the form itself has model and popup both set to yes)>>

 I've never tripped over that before and I can't understand why that would be an issue...the form has the focus.

Jim.
0
mbizupCommented:
Possibly the a dialog argument?  That does cause forms to have a different 'feel' .. but I would think the other arguments would be fine.
0
mbizupCommented:
Cellphone auto corrected my post.  That should be acDialog .
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.