Subform writes but doesn't read

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Thanks for the advice.

I have deleted and re-created the link, stared at the link, etc. It seems OK.
I'm still stuck.
 
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
 
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...
 
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.
 
Back
Top