Forms and Dynaset Inconsistent

[narotosensei]

I am having trouble with my forms. I have some of my forms set to Dynaset Inconsistent Data because they are based off of more than 3 tables. But, when i go to add a record in, the form doesn't remember and the record navigation selectors don't update. So any ideas?
http://www.megaupload.com/?d=YJXZPQTR

 

[smig]

depand what kind of connections you have in your joins.
te file you uploaded is unavailable so it's kinda difficult to look at it.

 

[narotosensei]

http://uploading.com/files/5da944em/paymee.accdb/

try this one

 

[boblarson]

1. Your forms should be Dynaset.

2. You should not be trying to use the three tables because you have one to many relationships. The other two tables should be SUBFORMS.

 

[narotosensei]

1. Your forms should be Dynaset.

2. You should not be trying to use the three tables because you have one to many relationships. The other two tables should be SUBFORMS.

Thanks that worked pretty good now they update so much better!
Thanks for the great advice!

 

[boblarson]

Glad to hear you got it sorted.