GomaPile
Active Member
- Joined
- Jul 24, 2006
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hello All, searching websites for a solution - is this possible...
Ive created 3 individual Tables for a Food Menu: table1, table2, table3 in a single column one after another from (A1) downwards etc and a space between each tables.
When using the build in Form called ShowDataForm it always goes to the first table1 everytime.
Is it POSSIBLE using 1 Comand Button to add new data to a specific Table when its selected, without errors or writing over another existing table. And then automatically inserts a new row underneath that table pushing the other tables downwards to the next Cell-Row.
For Example
TABLE1
(A1) PLUCode | Breakfast | Indicator
(A2) 100 | eggs | Amber
(A3) 101 | bacon | Red
(A4) 102 | croissant | Amber
TABLE2
(A6) PLUCode | Lunch | Indicator
(A7) 200 | ham | Amber
(A8) 201 | salad | Green
(A9) 202 | avocado | Green
**would like to add new data here
**pushing table3 downwards
TABLE3
(A11) PLUCode | Dinner | Indicator
(A12) 300 | soup | Green
(A13) 301 | vegetables | Green
(A14) 302 | custard | Amber
Cheers
Nasa2 (GomaPile)
Ive created 3 individual Tables for a Food Menu: table1, table2, table3 in a single column one after another from (A1) downwards etc and a space between each tables.
When using the build in Form called ShowDataForm it always goes to the first table1 everytime.
Is it POSSIBLE using 1 Comand Button to add new data to a specific Table when its selected, without errors or writing over another existing table. And then automatically inserts a new row underneath that table pushing the other tables downwards to the next Cell-Row.
For Example
TABLE1
(A1) PLUCode | Breakfast | Indicator
(A2) 100 | eggs | Amber
(A3) 101 | bacon | Red
(A4) 102 | croissant | Amber
TABLE2
(A6) PLUCode | Lunch | Indicator
(A7) 200 | ham | Amber
(A8) 201 | salad | Green
(A9) 202 | avocado | Green
**would like to add new data here
**pushing table3 downwards
TABLE3
(A11) PLUCode | Dinner | Indicator
(A12) 300 | soup | Green
(A13) 301 | vegetables | Green
(A14) 302 | custard | Amber
Cheers
Nasa2 (GomaPile)