Help - subform lost contact

[Joe Z]

I need help with form/subform lost recognition. I am not sure what happened but my subform is no longer recognized on my form. This may have happened afte a record (in sub form) was deleted. My information on this is not clear, however here it iswhatI have.

The outline of the subform is there, but no records show. Formulas referencing subform no longer work. When I go to the subform itself (ie not on the main form), the structure is there but no records are shown. Looking at the record source query all records are displayed. I am baffled! The link master fields & link child fields appear ok

I am relatively new to Access but this does not make sense to me. Am I overlooking the obvious. Do you have suggestions on what I can do to try to ferret out this problem? Any suggestions would be greatly appreciated.
Thanks,

 

[SydneyGeek]

How long would it take to re-create the subform? Sometimes, that is the best option.

Denis

 

[boblarson]

Make sure you don't have the main form's ALLOW EDITS set to NO (ran across that yesterday with someone in another forum).

 

[Joe Z]

After fooling around with it for way too long - I thought I could learn something by figuring out what happened - I decides it was much easier to just create a new subform. I will go back a check that "Allow Edits", I'm still a little curious and certainly do not want to make the same mistake in a situation that will be more difficult to fix. I'm sure it had something to do with the record deletion.
Thanks,

 

[Joe Z]

Oh, by the way, I forgot to say that you two guys have great websites - very beneficial.