Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

Having the Subform save a record even if it is Blank

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chip - 12 Mar 2007 16:58 GMT
Howdy from Oklahoma!!!

I am new to ACCESS and have a problem with a form/sub-form saving records.  
I have a form (call it "FormA") that has a subform (call it SubB) from a
different table.  

Sometimes Form A has data entered and not SubB but when I look at the tables
there is only a record for FormA and SubB does not generate a record.  All
works fine if i add data to SubB but i want the form to build basically an
empty record if no data is entered.  (this is because I am manipulating both
records later and if there is not a record for SubB then it errors out and
stops.)

So I am needing a way to make sure that a record is created for both the
Main form and the subform even if no data is input into the subform.

Any assistance would be greatly appreciated and as always THANKS IN ADVANCE!!!

Chip
ruralguy - 12 Mar 2007 20:13 GMT
You will need to Change *something* in one of the fields in the SubForm so
the record get Dirty and Access will save it.

>Howdy from Oklahoma!!!
>
[quoted text clipped - 15 lines]
>
>Chip

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.