T
Ticotion
Hi
I have a main form where I have placed two subforms (Sub1 and sub2)
On sub i I have a combobox and a textbox. Sub2 shows values from the table
(tbl1) that SUB1 saves records to. I have two questions:
1. The Save button on sub1 should save the values selected in the combobox
and written in the textbox in the form records source. The user should then
have the possible to choose and input other values, hit save and a new record
should be genereted in the record source. How is this done?
2. The sub2 should always show the latest updated records from tbl1. How do
you requery this after each time the save button is hit in sub1?
Thanks for all your help
Ticotion
I have a main form where I have placed two subforms (Sub1 and sub2)
On sub i I have a combobox and a textbox. Sub2 shows values from the table
(tbl1) that SUB1 saves records to. I have two questions:
1. The Save button on sub1 should save the values selected in the combobox
and written in the textbox in the form records source. The user should then
have the possible to choose and input other values, hit save and a new record
should be genereted in the record source. How is this done?
2. The sub2 should always show the latest updated records from tbl1. How do
you requery this after each time the save button is hit in sub1?
Thanks for all your help
Ticotion