Add unbounded text boxes to datasheet view in one form

[jaryszek]

Hi People,

how are you? In Poland there is a huge winter behind my window

Issue:
I would like to do a split form or something like this where
there are text boxes and one combobox which is bounded with table1.

Below these controls should be datasheet view with table2 and different fields bounden to this table.

If user choose ticket number from combobox these text boxes should be fullfilled with data from table1.
And if user click button this data should be add as new record into table2.
But if user will change ticket number only textboxes should be changing.

And last one thing : if the ticket number choosen by user from table 1 will be also in table 2 - the appropriate record from table 2 should be showed and be ready to do changes.

Uff this is very difficult for beginner like me.

I was trying to do this with split form but problem is with unbouding one on table with another. But It didn't work.

Please advice,
Jacek Antek

 

[jaryszek]

Anyone please ?

Jacek

 

[static]

You only need one table.

Use one form and filter the records.

Or a main form / sub form with the subforms records filtered by a control on the main form.

 

[jaryszek]

Thank you static.

Ok i have found the solution:

https://s28.postimg.org/6lmi3rlx9/solution.png

I did a form for table2.

On this form there is a combo box which is no bounded to table 2 - only for table 1.

If you choose the ticket number from table 1 the Dcount function is running and filling
fields "Temat zgłoszenie", "PESEL", "Imię i Nazwisko" and "Spółka" from table1.

If the ticket number exists in table 2 there is also Dcount function but from table 2.

So summury:
1. combobox is not bounded to table1, only to table 2.
2. data are fullfilled depending on existing data. If existing data is in table 1 - treat table 1 as source for fields, otherwise take table 2.

Jacek