By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

DblClickNotInList

P: n/a
DD
Hi
Two forms
frmMain and frmCustomer
I have the NotInList DblClick working from the CustomerID COMBO in the
frmMain to the point where i can enter a new record in the frmCustomer
and the new record is updated in the frmCustomer but i cant get it to
update in the CustomerID combobox until i close and reopen the
frmMain.
I have added Me![CustomerID].Requery and various other attempts

any ideas
DD
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 27 Jan 2004 14:59:04 -0800, da**********@bigpond.com.au (DD) wrote:
Hi
Two forms
frmMain and frmCustomer
I have the NotInList DblClick working from the CustomerID COMBO in the
frmMain to the point where i can enter a new record in the frmCustomer
and the new record is updated in the frmCustomer but i cant get it to
update in the CustomerID combobox until i close and reopen the
frmMain.
I have added Me![CustomerID].Requery and various other attempts

any ideas
DD

Try resetting the RowSource of the combo. Use the frmCustomer's
AfterInsert event. Something like...

Dim strSrce As String

strSrce = Forms!frmMain!cboCustomer.RowSource
Forms!frmMain!cboCustomer.RowSource = ""
Forms!frmMain!cboCustomer.RowSource = strSrce

Resetting it will automatically requery it.

- Jim
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.