Solved subform recordsource (1 Viewer)

[ClaraBarton]

I'm back to this form: lstfrmEdit. I cannot get the recordsource to show up in the upper left subform (Lists). I notice the number of records showing is the same as the query but the fields don't show and can't be selected.

 

[moke123]

I get this error opening the form

I dont see that the form or subform have record sources.

 

[ClaraBarton]

I apologize. I created a new file.

 

[moke123]

Hate to say it but . . .

 

[moke123]

I deleted the control causing that error.

It looks like you are setting the record source in the after update of cboLists. The problem is you don't have control sources set on the subform controls. (ie. ID, Display)

 

[ClaraBarton]

I did have different subforms. I was told that was way too much work and this is the proper way. I've done it this way and now I'm into this and I'd like to get it to work. You're right, the records are not available until selected from the cbo. The recordsource is then working because the record count is correct but I can't get the fields to show. I've used the same queries in the form outside the main form and it works fine.https://www.access-programmers.co.uk/forums/threads/subforms-not-updating-properly.326210/

 

[moke123]

See copy of lstFrmEdit

 

[Pat Hartman]

I'm back to this form: lstfrmEdit. I cannot get the recordsource to show up in the upper left subform (Lists). I notice the number of records showing is the same as the query but the fields don't show and can't be selected.

Did you download the version of the app where I fixed this form for you?

 

[arnelgp]

is this what you meant.
see the After update event of the combobox.

 

[ClaraBarton]

the point is to be able to edit the fields. Can you do that in a list box?

 

[ClaraBarton]

YES! YES! Thank you so much! It Works!

 

[Pat Hartman]

YES! YES! Thank you so much! It Works!

I guess you didn't actually test the form. You can't add Authors and form 3 is not sync'd with form 2. The combos on form 4 don't work correctly. But aside from that, I guess it works.

 

[ClaraBarton]

It's a work in progress. One thing works.... I go to another. I had them all working till I changed all the subforms out and went to one at your suggestion.