I have been stuck now for days trying to figure out how to make this work. I have looked at the articles for form filtering and cascade filtering. Code is very new to me and I am having difficulty understanding the examples in code. The situation I am working on right now, I haven't been attempting code use at all.
I need to make a continuous sub form work while not duplicating fields in tables.
The main form is one record from a separate table and the sub form is all the parts connected to that main record.
The sub form involves 3 tables connected by a name field.
Table 1 - Name, type, location info/details
Table 2 - days, hours availability (separate record for each day and time slot)+ name, type
Table 3 - all of table 2 plus other info
The sub form is bound to table 3.
If I keep the tables as above, then I have no issues with the sub form.
I enter type and date then a combo box with the below code gives me matching names to choose from.
Expand|Select|Wrap|Line Numbers
- SELECT Table2.Facility, Table2.DayofWeek FROM Table2 WHERE (((Table2.Type)=Forms!MainForm!SubForm.Form!Type) And ((IIf((WeekdayName(Weekday([Date]))<>[DayofWeek]) And ([Type]="Pool"),True,False))=False));
I am lost as to how to make this work without duplicate fields in tables.
I would like to keep it as a continuous form so I can see all of the parts I am adding to the main form.
There is more to the sub form, but this is where I am stuck right now.
I hope I provided enough information and was clear. My apologies if not.