I have a form for entering and view

[TomDuCrosbie]

I have a form for entering and viewing customer info. Once the customer's name is entered, there is and after update event to create the ClientID. There is an After Update event for ClientID Me.Requerry . I had the understanding that this would make the data show in the table, so when other info in sub forms is entered, everything works.

however, the data doesn't show up in the table until the form is closed. I can't have users enter the customers name, close the form, then re-open the form inorder to enter more information.

If the form isn't closed the error "The data has been saved to the database, but can not be displayed be cause of conditions of the underlying record source."

The error is because the subforms are all linked with the ClientID which isn't inputed into the table untill the form is closed.

Any sugestions?

Tom

 

[TomDuCrosbie]

Here's the set up

The form displays customer info, with a sub form displaying the spouses info (customer and spouse are saved in tblContact each with their own ClientId and their SpouseID = their spoused ClientID). On page 2 there are 3 tabs each with subforms linked to the main form by ClientID.

All the forms have either a view as the record source or a table.

 

[Nowell]

Hi,

try setting the unique table property on the form that is giving you the problem.

 

[BobJacksonNCI]

Tom,

I just fought the same battle, so I think the following will help you. Just changed my record source from a Select statement to a View and haven't implemented live, but it does eliminate the error message.

http://support.microsoft.com/default.aspx?scid=kb;en-us;287627&Product=acc2000

HTH,
Bob
Your mileage may vary, but following the guidelines in faq181-2886 will help you reach your goal.

 

[TomDuCrosbie]

I'd already taken look at that article too. That solved the problem only part of the time. What I found out is i have a search form that opened the main form inserting a where condition on the opening. So if the form opend blank, the forms filter read "ClientID =" so when a client ID was generated for the form, it didn't match the Filter, so it couldn't display the data untill I closed it, searched for the person again, and now the filter matched the data.