Can write but can't read from subform

  • Thread starter Thread starter blue room
  • Start date Start date
B

blue room

I have a form with a subform. The subform's record source is a query, which
I have bound to the controls on it. Problem is, when I enter data into the
subform, the data gets written to the table, but when I navigate back one
record and then forward one record in the main form, I don't see the records
reflected in the subform's controls.

Is there something dumb that I am missing? If I open up the table, I can see
what I entered in the subform. Why can't I view the records in the subform
since I have set a record source to that table (well a query which is the
table)?
 
Think I got it... the subform's query's criterion was a textbox I hadn't
named yet in the main form.

Strange that I was not prompted for the parameter when the subform was
opened along with the main form. Does access ignore this if the Link
Child/Master relationships are set?
 
Back
Top