AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question QUESTION: Hi Scott,
I have a Form and when I click a button to add a new
record.The first record never gets added/inserted.It
generates the autonumber in the form but on click of Close
button in the form the added record is not in the form as
well in the database.But the subsequent records gets added
and can be viewed in the form.
Can you please help.
ANSWER: When you open the form is there already a record displayed? Do you then type over what's in that record and then hit the New Record button to add a new record?Scott<>Microsoft Access MVP 2007Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: Hi Scott, Initially there will be no records for that subform.MainID from Main form is linked to this subform.MainID will have many subID's.When I click on Add a record for this MainID first record is not added.And again when I try to create a record,it is created and displayed in Form.No problem with the subsequent entries.Only the first entry is not getting added.
ANSWER: The first entry in the subform or in the mainform?
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: Main form is that can have only one MainID (priamry key) and it can have many SUbID's.Entry not added in Subform
Answer Frankly, I haven't a clue. If you have an embedded subform and you add a recor din the subform, it should create a record in the table the subform is bound to.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
