Dmitrijs (DJ
New member
- Local time
- Today, 14:28
- Joined
- Sep 21, 2020
- Messages
- 2
Good afternoon
I have form1 with datasheet view in default. Data for it is filtered by query1 where criteria is "<>0" (for number) and "False" (for tickbox). Table contains: Pallet_ID (which can be duplicated), Quantity, Date_Time, Investigated?(Tickbox), Comments, Color((combo box)This is to higlight line with conditional formating in form1). Also I've created another query2 with all data from the main table. In a query1 I have inserted Subdatasheet from query2 where Pallet_ID is linked.
Can I make this form1 in Subdatasheet view with + and - like I have managed to do it with query1? Form1 shows data I need but there is no option to expand or collapse + and -.
Regards
DJ
I have form1 with datasheet view in default. Data for it is filtered by query1 where criteria is "<>0" (for number) and "False" (for tickbox). Table contains: Pallet_ID (which can be duplicated), Quantity, Date_Time, Investigated?(Tickbox), Comments, Color((combo box)This is to higlight line with conditional formating in form1). Also I've created another query2 with all data from the main table. In a query1 I have inserted Subdatasheet from query2 where Pallet_ID is linked.
Can I make this form1 in Subdatasheet view with + and - like I have managed to do it with query1? Form1 shows data I need but there is no option to expand or collapse + and -.
Regards
DJ