Problem with the subform

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Combo Box Values 5
Data type mismatch 2
Combo Boxes 11
Combo Box Problems 2
Sync Main Form with Subform after Combo Selection 2
Combobox column 1 6
Combo Box 2

Top