Continued Subform Problems

G

Guest

I have a form with two subforms. The first subform is based on 1 table. It
works great. The second subform is based on 2 tables and it works terrible.
The problem is inputing data and displaying it.
On the fields of the 2nd subform based on its first table everything goes in
alright, but on the fields based on the second table, the subform won't even
let me input data.
When I scroll away from the mainform entry containing that record and then
back to see if it displays, what it allowed me to enter is not displayed.

Keep in mind the mainform fields function properly, the other subform fields
function properly, no matter how many records I input or how many times I
scroll to and away from.

I checked the data entry and it's on no. So that isn't the problem. I
tried changing the join feature, but that didn't fix it. I had this problem
before and somehow fixed it, now I've forgotten how. I'm not sure what I did
to change it so it doesn't work, but I still can't figure out how to fix it.
Suggestions?

Also, are there any other suggetions about how to learn to work with subforms?
 
J

jahoobob via AccessMonster.com

When you say the 2nd subform is based on two tables. If this is through a
query you may have to change the subform's Recordset Type to Dyanaset
(Inconsistent Updates)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top