Not in List problems

[Chris]

Hi,



I've got a fairly standard question that has been answered on many groups
before. Unfortunately I can't make any solutions work for me.



I have a form (frmDebts) that lets users enter details of debts to banks.
They will select the bank from a combo box (cboBank). This value will
filter the second combo box (cboBranch) so that it only shows the branches
for that particular bank. Then the user will enter the amount of debt



However, when a Bank or Branch does not exist I would like to use the
notinlist event to open a form (frmBankName containing a subform
frmBankBranch) (using acDialog) to allow the user to enter the bank's name,
branch and address details.



All of the following work. However, When I shut the form - frmBankDetails,
the cboBank is still in dropdown mode and has not been re-queried.





Can someone please help? I'm all out of ideas!

 

[Ed Robichaud]

While that may work, the user process I use is to display a msgbox on the
NotIn List event that prompts the user to either re-enter an existing name
or to "double-click" to add a new one. Put your OpenForm command in the
OnDoubleClick event of the combobox, then refresh your main form when the
AddNew form closes so that any new values will be displayed in the combobox
for selection.
-Ed

 

[Chris]

Do you know why I can't refer to the parent form? When I try to close the
form I get the message, "Microsoft access can't find the form "formname"
referred to in your macro or visual basic code.

I've tried
Forms!frmName.Forms.Visible = True
me.Parent!frmName.visible = true
amongst many others with no success

 

[Chris]

Disregard the last message please. An alien took over my brain and made me
write it.