POP UP form for Data Entry

[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.

 

[Wayne-I-M]

Hi Abdul

I just dont want to use a combo box or a list
box for this purpose.

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