Hello...and thanks in advance for any help.
I got a form with fields: Class ID (unique), Class Date, Class Name
with a subform with fields: Class ID (linked to the same field in Master), OwnerName, DogName
The subform is based on a query; and the query is based on a table. The link between the subform/query/table works fine; if I enter new data in one, it shows up in all. My challenge in the "method" I have to use to enter data.
The fields in the subform are currently text boxes, requiring me to "type" in the new data. If I change to a combo box or list box linked to the query that is the source of the subform, my only "list" options are those entries that are all ready in the source table, which limits me adding "new" info. If I change the record source to another query which has the full data set (such as the source table for Owner or Dog Name), the subform fields give me the full list but are then no longer linked to one another (i.e. I can pick an owner name from the drop down but, it doesn't the limit the DogName field to only those associated with that owner...it still gives me the ENTIRE list of dog names).
Hopefully I've provided enough info on the problem. If not, please let me know what else I need to provide. (Note: I generally work in the form design mode and with macros as I'm not great with writing the code directly).
Thanks, again.
I got a form with fields: Class ID (unique), Class Date, Class Name
with a subform with fields: Class ID (linked to the same field in Master), OwnerName, DogName
The subform is based on a query; and the query is based on a table. The link between the subform/query/table works fine; if I enter new data in one, it shows up in all. My challenge in the "method" I have to use to enter data.
The fields in the subform are currently text boxes, requiring me to "type" in the new data. If I change to a combo box or list box linked to the query that is the source of the subform, my only "list" options are those entries that are all ready in the source table, which limits me adding "new" info. If I change the record source to another query which has the full data set (such as the source table for Owner or Dog Name), the subform fields give me the full list but are then no longer linked to one another (i.e. I can pick an owner name from the drop down but, it doesn't the limit the DogName field to only those associated with that owner...it still gives me the ENTIRE list of dog names).
Hopefully I've provided enough info on the problem. If not, please let me know what else I need to provide. (Note: I generally work in the form design mode and with macros as I'm not great with writing the code directly).
Thanks, again.