Subform writes but doesn't read

R

Rog

This is probably a very simple question from a newbie.

I have a form with a subform on it.
The form is based on a table and the subform is based on an updateable query.
I can enter data into the form and the subform, and the data is written to
all of the proper tables correctly.
However the subform is never populated with data when I move to a row with
data for the subform.
I’m not getting an error message, the subform just does not populate.

Can anyone give me some advice?
Thanks!
 
W

Wayne-I-M

Hi Rog

Sounds to me like there may be a problem with the "link".

Open the main form in design view and select the subform Data. Check the
Link Child and Link Master fields are in place - note there must be a field
in both form of the same data type so the forms can "link" correctly.
 
R

Rog

Thanks for the advice.

I have deleted and re-created the link, stared at the link, etc. It seems OK.
I'm still stuck.
 
W

Wayne-I-M

Hi Rog

I also find the staring at things tend to make them better - Open the
subform in design view and check that the data column is not set to Data
Entry = Yes

Let me know if this works
 
R

Rog

You fixed it.

Thanks !!

Wayne-I-M said:
Hi Rog

I also find the staring at things tend to make them better - Open the
subform in design view and check that the data column is not set to Data
Entry = Yes

Let me know if this works
Click to expand...
 
W

Wayne-I-M

No - you fixed it. Sometimes you, as the developer, just need to sit and
think "what could be the problem" and "how do I fix it". You could look in a
book, look on the web, ask in a forum or simply take a stab in the dark.
Either you will sooner or later fix the probelm.

Good luck with you project.
 
Top