A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I force the record to save?



 
 
Thread Tools Display Modes
  #1  
Old February 19th, 2010, 12:52 PM posted to microsoft.public.access.forms
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default How can I force the record to save?

I have a form with two subforms. As I inpyt all the data everything looks
fine. I use the navigation buttons to move to a new record. BUT all the data
is not being saved in the tables that the subforms are bound to. Could anyone
give me a starting point as to where I should start looking?
Just spent an hour inputting the data only to look in the tables and find
there's nothing there!
Thanks
Tony

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

  #2  
Old February 19th, 2010, 01:13 PM posted to microsoft.public.access.forms
Stefan Hoffmann
external usenet poster
 
Posts: 991
Default How can I force the record to save?

hi Tony,

On 19.02.2010 13:52, TonyWilliams via AccessMonster.com wrote:
I have a form with two subforms. As I inpyt all the data everything looks
fine. I use the navigation buttons to move to a new record. BUT all the data
is not being saved in the tables that the subforms are bound to. Could anyone
give me a starting point as to where I should start looking?

Check whether the link master field/child field properties are set as
needed.

Check the code behind your forms. May saving is suppressed there.

Just spent an hour inputting the data only to look in the tables and find
there's nothing there!

You should test before working with your forms


mfG
-- stefan --
  #3  
Old February 19th, 2010, 03:56 PM posted to microsoft.public.access.forms
TonyWilliams via AccessMonster.com
external usenet poster
 
Posts: 117
Default How can I force the record to save?

Stefan, I deleted the links then recreated them exactly the same and it now
works!
Odd?
Thanks for your tip.
Tony


Stefan Hoffmann wrote:
hi Tony,

I have a form with two subforms. As I inpyt all the data everything looks
fine. I use the navigation buttons to move to a new record. BUT all the data
is not being saved in the tables that the subforms are bound to. Could anyone
give me a starting point as to where I should start looking?

Check whether the link master field/child field properties are set as
needed.

Check the code behind your forms. May saving is suppressed there.

Just spent an hour inputting the data only to look in the tables and find
there's nothing there!

You should test before working with your forms

mfG
-- stefan --


--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.