Can write but can't read from subform

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)?
 
B

blue room

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?
 

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

Similar Threads


Top