Use filter on subform

  • Thread starter RJS76 via AccessMonster.com
  • Start date
R

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

TonyT

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

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,
Click to expand...
[quoted text clipped - 19 lines]
Is there a simple way to do this? Thanks in advance for your effort.
Click to expand...
Click to expand...
 
Top