473,406 Members | 2,377 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Not able to automagically add the next record after entering in a record

anoble1
245 128KB
I have searched but not sure how to explain the simple thing I am looking for. I have a form that I put data in and fill out the row of data. Before once you started typing a new row would appear below. Now you can't get a new row so you can't add any records. All the Properties look okay on the form I think... I am missing something. Any help? I attached 2 pictures. One of them is missing the "New Record" popping up. The other has a blank on the way i would like it.
Nov 3 '16 #1

✓ answered by jforbes

I would edit just the SubForm and see what the Property is for AllowAdditions.

I would also check the properties for the SubForm, on the MainForm to make sure that it's not Locked and that it is Enabled.

Maybe, make sure that the RecordSource of the SubForm is updatable.

Lastly, maybe there is code that modifies the Properties above, like Allen Browne's Locking bound controls

3 654
jforbes
1,107 Expert 1GB
I would edit just the SubForm and see what the Property is for AllowAdditions.

I would also check the properties for the SubForm, on the MainForm to make sure that it's not Locked and that it is Enabled.

Maybe, make sure that the RecordSource of the SubForm is updatable.

Lastly, maybe there is code that modifies the Properties above, like Allen Browne's Locking bound controls
Nov 3 '16 #2
anoble1
245 128KB
hmm... Says my Recordset is not updateable...
Nov 3 '16 #3
anoble1
245 128KB
Thanks @jforbes. I took my GroupBy out of the query and it is working now.
Nov 3 '16 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Warmonkey | last post by:
Hi there, I have been frustrated by the 'next record' problem when a user tabs off the last control on a form. I have tried a couple of the suggestions listed on the newsgroup, but so far...
2
by: Doslil | last post by:
hi, I have a drop down list on the main form which has a query attached to it.Looks like the record is not moving to the next record,cos when I select the next record from the list it gives an...
15
by: Susan Bricker | last post by:
Greetings. I have a Mainform with a subform. The Mainform has single record format and subform has continuous form format. When the Mainform opens, I force allowadditions and allowedits to FALSE...
7
by: todholt | last post by:
Hello, I am trying to bypass a form's automatic update, and instead call a stored procedure in sql server. I am using continuous forms. The problem I am having is with returning to the next...
27
by: Kim Webb | last post by:
I have a field on a form for project number. I basically want it to be the next available number (ie 06010 then 06011 etc). In the form I create a text box and under control source I put: =!=...
10
by: giannis | last post by:
How can i know ("see") the next record using the BindingSource without move to the next record ?
2
by: voroojak | last post by:
Hi How can i put save record and next record in one button. in my save record i put the calculation of the text boxes. i have a total field that the sum of the other field is in there and it wil be...
1
by: stuart | last post by:
I have a list of records in a subform that a user can either edit or delete. This is an unbound form. If the user deletes a record, I want to refresh the form, and then position the cursor on the...
1
by: anthony lapenna | last post by:
when advancing to the next record, all the info clears in my form. Some info I would like to stay up on the form. Especially if I have 100 entries and the item is person entering data
4
by: JonHuff | last post by:
I want to prompt users before they are allowed to go to the next existing record, search for a record, or create a new record. I display the records on a form. The form just opens to the 1st...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.