Recent content by LeeMo127

I've managed to solve my problem so I'll post what I did that solved it and where I went wrong. How I solved this issue for me. Issue: Only one record displaying on a dynamic subform. Solve: I had to declare the linked master/Child fields in the VBA as empty. To be clear these were visibly...

The Link Master and Child are not set but maybe I have to do this in the VBA and not the while in design mode on the main form.

The subform that I use as the source object is in datasheet view. I'm not sure what you mean by datasheet in continuous mode. Perhaps there is a property I have not set, which is likely. I do not like the look of the ordinary continous form view. I just changed the it to continuous form view in...

The record count in the subform when applying the SQL statement to the subform form record source is only 1. Even though the subform form (and the query for that form), when opened outside of the form, has all the correct records displayed.

I will give it a try. I'm not sure this will cause ALL the records that are in the query to display however. Or atleast I'm not sure how the DoCmd go to the First Record will help. I appreciate the the thought. Thanks.

Hi All, I've been having no luck with my subform display all records. I have a main form with an unbound subform. In the VBA for the Form_Current event, a field (ID) from the main form is used in a function that determines the dependencies (all children) of that record. This is then used to...

I'm sure the dark mode will come in handy when I'm banging my head against the wall late at night! I would appreciate the dark mode; the neighbours won't appreciate the banging noise!

A lot of google searches while I've been trying to learn and develop the db. The new look is great btw. I was slow to say hi a few weeks ago.

Hi All, Like most introductions here, I'm new to MS Access and slowly being won over by all things Access. I hope that one day I can help and contribute to the group as much as I learn and take from it! I'm currently working with Parent/Child relationship type data so any advice is welcomed...