how Combo Box can update data from a table

[savas_karaduman]

I am planning a single Form by which user may enter data into several
tables.

I put Combo Box which receive data from table (lets say `T_Customer`).
At the same time, I put T_Customer subform into same Form too. I put
it, because i want user to enter new Customer data to the T_Table if he
can not find it in Combo Box.

Problem is that Combo Box can not show recently entered Customers
automatically. Is there anyway to solve this problem ?

[Ira Solomon]

Assume that your main form is named MF and the combo box is
cmbT_Customer.

Then in the code for the after_insert event of the subform you would
have:
forms!MF!cmbT_Customer.refresh.

This will cause the query behind the combo box to excute and the new
name will be in there.
If there is an option to change the name in the subform, then place
the same line in the the after_update event of the subform.

Good luck
Ira Solomon
On 1 Nov 2006 07:12:57 -0800, sa*************@yahoo.com wrote:

>I am planning a single Form by which user may enter data into several
tables.

I put Combo Box which receive data from table (lets say `T_Customer`).
At the same time, I put T_Customer subform into same Form too. I put
it, because i want user to enter new Customer data to the T_Table if he
can not find it in Combo Box.

Problem is that Combo Box can not show recently entered Customers
automatically. Is there anyway to solve this problem ?

[savas_karaduman]

I am so appreceated for your help. it is working !!!!

Ira Solomon wrote:

Assume that your main form is named MF and the combo box is
cmbT_Customer.

Then in the code for the after_insert event of the subform you would
have:
forms!MF!cmbT_Customer.refresh.

This will cause the query behind the combo box to excute and the new
name will be in there.
If there is an option to change the name in the subform, then place
the same line in the the after_update event of the subform.

Good luck
Ira Solomon
On 1 Nov 2006 07:12:57 -0800, sa*************@yahoo.com wrote:

I am planning a single Form by which user may enter data into several
tables.

I put Combo Box which receive data from table (lets say `T_Customer`).
At the same time, I put T_Customer subform into same Form too. I put
it, because i want user to enter new Customer data to the T_Table if he
can not find it in Combo Box.

Problem is that Combo Box can not show recently entered Customers
automatically. Is there anyway to solve this problem ?