P
Praveen Manne
Hi,
I have a form which contains Last Name, First Name and SSN combo boxes,
which will get their values from table 'tblPhys'
The First name and SSN Combo boxes contain a query in the Row Source.
First Name Query: Filters the first names for the apporpriate Last Name
selected
SELECT DISTINCT tblPhys.FN FROM tblPhys WHERE tblPhys.LN="" &
Forms!frmTransGrid!LN & "";
SSN Query: Filters the SSN's for the appropriate Last Name and First Name
Selected.
SELECT tblPhys.ssn FROM tblPhys WHERE tblPhys.LN="" & Forms!frmTransGrid!LN
& "" and tblPhys.FN="" & Forms!frmTransGrid!FN & "";
This form is working fine without any problem.
I have an another form, which includes the above form as its sub form.
Now the problem is when I select the Last Name, and when I go to the First
Name Combo for selecting the appropriate First Name,
it is popping up a box asking me to fill the Last Name once again. And when
I filled that box with the correct value, then the first name combo is
showing the corrct value. If I didn't fill that box, Fist Name combo is
showing Null.
I want to get the first name combo to be filtered, after I selected the Last
Name (as it is working in the Main form)
How to get rid of this problem? PLEASE HELP
Thanks
Praveen Manne
I have a form which contains Last Name, First Name and SSN combo boxes,
which will get their values from table 'tblPhys'
The First name and SSN Combo boxes contain a query in the Row Source.
First Name Query: Filters the first names for the apporpriate Last Name
selected
SELECT DISTINCT tblPhys.FN FROM tblPhys WHERE tblPhys.LN="" &
Forms!frmTransGrid!LN & "";
SSN Query: Filters the SSN's for the appropriate Last Name and First Name
Selected.
SELECT tblPhys.ssn FROM tblPhys WHERE tblPhys.LN="" & Forms!frmTransGrid!LN
& "" and tblPhys.FN="" & Forms!frmTransGrid!FN & "";
This form is working fine without any problem.
I have an another form, which includes the above form as its sub form.
Now the problem is when I select the Last Name, and when I go to the First
Name Combo for selecting the appropriate First Name,
it is popping up a box asking me to fill the Last Name once again. And when
I filled that box with the correct value, then the first name combo is
showing the corrct value. If I didn't fill that box, Fist Name combo is
showing Null.
I want to get the first name combo to be filtered, after I selected the Last
Name (as it is working in the Main form)
How to get rid of this problem? PLEASE HELP
Thanks
Praveen Manne