POP UP form for Data Entry

  • Thread starter Thread starter Abdul Shakeel
  • Start date Start date
A

Abdul Shakeel

Hi All,

I have a bank management database in which I 've a table named
frmBankTransactions one of its field required specific bank to be enter for
this purpose I 've set a combo box that lists all the banks from tblBanks, I
just want that I dont use a combo box for this instead I used a text box when
user double click on the text box it appears a form which contains a
List(ListBox) of all banks from tblbanks when user double click on specific
bank on that list it become part of the field of frmbanktransactions, could
any one help me in this regard, I just dont want to use a combo box or a list
box for this purpose.

thanks in advance.
 
Hi Abdul
I just dont want to use a combo box or a list
box for this purpose.
Click to expand...

Why ?? this is what combos and list boxes are for.

Oh well
Create a popup form with your combo (contain the bank names) on it.
Create a button on frmBankTransactions to open your popup
Set the AfterUpdate on the combo on to the popup to

Private Sub BankCombo_AfterUpdate()
Forms!frmBankTransactions!TextBox = Me.BankCombo
End Sub

Good luck
 
Back
Top