C
Chris
Hello all,
I have a form (frmCreditors) which contains a combobox (cboCreditors) based
on a table (tblcreditors). I would like the user to be able to add items
into the combobox by the comboboxs' not in list event. I would like a form
(frmFurtherDetails) to appear that the user can enter in details of the
creditor (form also based on tblCreditors).
q1) When I close the form (frmFurtherDetails) how can I make the original
value appear in the cbobox "cboCreditors"rough
2) How do I stop the code from running through to tell me that the item is
not in the list.
To clarify - user enters "The royal Bank of Scotland" into cboCreditors.
frmFurtherDetails opens with "The Royal Bank of Scotland" in the creditor
name txtbox. Details of the creditor are added (branch, address etc) the
form is closed, cboCreditors is requeried and displays "the royal bank of
Scotland"
I have a form (frmCreditors) which contains a combobox (cboCreditors) based
on a table (tblcreditors). I would like the user to be able to add items
into the combobox by the comboboxs' not in list event. I would like a form
(frmFurtherDetails) to appear that the user can enter in details of the
creditor (form also based on tblCreditors).
q1) When I close the form (frmFurtherDetails) how can I make the original
value appear in the cbobox "cboCreditors"rough
2) How do I stop the code from running through to tell me that the item is
not in the list.
To clarify - user enters "The royal Bank of Scotland" into cboCreditors.
frmFurtherDetails opens with "The Royal Bank of Scotland" in the creditor
name txtbox. Details of the creditor are added (branch, address etc) the
form is closed, cboCreditors is requeried and displays "the royal bank of
Scotland"