Creating

[TomDuCrosbie]

Ok, this is probably pretty simple, but i need a fresh perspective on it.

My form has 4 tabs 1st is customer profile, 2nd contacts, 3rd accts, 4th, competition accts. The subforms on the 2-4 tabs are bound to their own tables. They are all related by ClientID.

Here's the problem: A user enters in the customer profile then moves to a different tab to enter in additonal information. The user now gets an error something to the effect of the data will be saved to the data base but can't be shown because it does't satisfy the critera of the underlying record set. The user has to close the form then bring it back up in order to compleete filling out their info. In effect, the data isn't being writen to the table untill the form is closed.

I know what you are thinking Me.Requery I tried that it doesn't work. The form has to close befor the data is writen.

The save record command doesn't work either.

I did find that access project and SQL dont like autonumber (identity) fields. so I changed it to programaticly assign a unique id using DMAX.

If you have any thought on how to get the data to write to the table without closing the form, please don't be shy. If you need more info about forms, tables, etc. let me know. I'll provide what you need.

Tom

 

[CajunCenturion]

Not sure, but what you might take a look at is whether or not there are fields in the table that have specific formatting requirements, but fields which do not appear on the first tab. The record is being initially written when you leave the first tab, and that may be what is generating this error. If you are in this situation, then you might consider assigning default values to those fields while still on the first tab.


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[TomDuCrosbie]

Thanks for the advise. I think I'm just going to rebuild the whole thing. There isn't very much data in it, since it never really worked, people didn't use it much. Whoever put this thing together the first time didn't do a good job. the whole thing is wierd. Thaks for the input though