Prev: How to add record in Subform which is in another Subform
Next: Adding a Field Name from Table/Query to Excel Export File
From: Maracay on 25 May 2010 08:53 Hi Guys, I have a blank continuous form to include some data, the thing is that when I finish the first line, I want to press enter and open a new line and include the second line and so on, but this is not happening, when I press nothing happen. I really appreciated if someone may help me with this. Thanks
From: golfinray on 25 May 2010 10:40 If it doesn't automatically add a new line, chances are your query or table is not editable. See if the arrow and asterisk at the bottom are highlighted. If not, they won't allow additions. -- Milton Purdy ACCESS State of Arkansas "Maracay" wrote: > Hi Guys, > > I have a blank continuous form to include some data, the thing is that when > I finish the first line, I want to press enter and open a new line and > include the second line and so on, but this is not happening, when I press > nothing happen. > > I really appreciated if someone may help me with this. > > Thanks >
From: Linq Adams via AccessMonster.com on 25 May 2010 12:23
If the form were Read-Only (could not be updated) the OP couldn't enter the first line! First question, is the form bound to a table or query, or is it unbound? An unbound form would behave in exactly this way. What happens when you hit <Enter> ? If the form's Cycle Property is set to the default of "Current Record Only" it should go back to the first control. To go to a new record when hitting <Enter> after the last field it would have to be set to "All Records." -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |