Use filter on subform

[RJS76 via AccessMonster.com]

Hi,

I have searched you knowledge base but I still don't know what to do. I hope
you guys can help me out.

First my database:

Table: Radius
Fields: Busnummer (Number) / Depot (Text) / Username (Text) / Password (Text)
/ Clientname (Text)

Query: qryRadius (based on table Radius)
This shows exactly the same information as the table Radius.

Form: frmRadius (based on query qryRadius)
This shows exactly the same information as qryRadius (columnar).

I would like to have another form which has frmRadius as a subform. On the
main form I would like to have a column in which I have to enter the
busnumber (field busnummer) and then in the subform (frmRadius) the password
which belongs to that busnumber is shown.

Is there a simple way to do this? Thanks in advance for your effort.

 

[Guest]

It would be simpler to do it all on one form if you can, have a combobox with
rowsource set to "SELECT BusNummer, Password from Radius" < add more fields
if you want them shown in combobox, set column widths to 3cm;0cm (hides the
Password) then in the after_Update event of the combobox have;
me.txtANotherTextBoxOnYourForm = me.cboComboBoxName.Column(1)

or you could just have both visisble in the combobox from the start

TonyT..

 

[RJS76 via AccessMonster.com]

Got it to work! Thank you for your help.

It would be simpler to do it all on one form if you can, have a combobox with
rowsource set to "SELECT BusNummer, Password from Radius" < add more fields
if you want them shown in combobox, set column widths to 3cm;0cm (hides the
Password) then in the after_Update event of the combobox have;
me.txtANotherTextBoxOnYourForm = me.cboComboBoxName.Column(1)

or you could just have both visisble in the combobox from the start

TonyT..

Hi,

[quoted text clipped - 19 lines]

Is there a simple way to do this? Thanks in advance for your effort.