populate a combo box

[JohnLute]

I've tried this before but never got it right. I'm wondering if anyone out
there could help me out?

I've got two combo boxes:
cbFacilityID
cbLineID

I want to populate cbLineID by what's selected in cbFacilityID. I know this
can be done but for numerous reasons I've been unable to get it!

Here are the row sources for the two combo boxes:

cbFacilityID
SELECT tblLocationIDsAddresses.numLocationAddressID
FROM tblLocationIDsAddresses;

cbLineID
SELECT tblFacLocAddIDsLineIDs.numLocationAddressID,
tblFacLocAddIDsLineIDs.LineID
FROM tblLocationIDsAddresses INNER JOIN tblFacLocAddIDsLineIDs ON
tblLocationIDsAddresses.numLocationAddressID =
tblFacLocAddIDsLineIDs.numLocationAddressID;

I need cbLineID to list the [LineID]'s according to the
[numLocationAddressID] as selected in cbFacilityID.

Thanks in advance for your help!

 

[Marshall Barton]

I've tried this before but never got it right. I'm wondering if anyone out
there could help me out?

I've got two combo boxes:
cbFacilityID
cbLineID

I want to populate cbLineID by what's selected in cbFacilityID. I know this
can be done but for numerous reasons I've been unable to get it!

Here are the row sources for the two combo boxes:

cbFacilityID
SELECT tblLocationIDsAddresses.numLocationAddressID
FROM tblLocationIDsAddresses;

cbLineID
SELECT tblFacLocAddIDsLineIDs.numLocationAddressID,
tblFacLocAddIDsLineIDs.LineID
FROM tblLocationIDsAddresses INNER JOIN tblFacLocAddIDsLineIDs ON
tblLocationIDsAddresses.numLocationAddressID =
tblFacLocAddIDsLineIDs.numLocationAddressID;

I need cbLineID to list the [LineID]'s according to the
[numLocationAddressID] as selected in cbFacilityID.

Set cbLineID's row source to:

SELECT numLocationAddressID, LineID
FROM tblFacLocAddIDsLineIDs
WHERE numLocationAddressID = Forms!theform.cbFacilityID

Then use:

Me.cbLineID.Requery

In both the form's Current event and cbFacilityID's
AfterUpdate event.

 

[JohnLute]

Hi, Marshall!

Since I mistakenly posted this here I also posted it in the Forms Coding
section. Dale Fye gave me almost the exact directions but didn't mention
putting Me.cbLineID.Requery in the form's Current Event. What happens if it's
not in the Current Event? I've tried the form without it in there and it
appears to be working properly.

--
www.Marzetti.com

I've tried this before but never got it right. I'm wondering if anyone out
there could help me out?

I've got two combo boxes:
cbFacilityID
cbLineID

I want to populate cbLineID by what's selected in cbFacilityID. I know this
can be done but for numerous reasons I've been unable to get it!

Here are the row sources for the two combo boxes:

cbFacilityID
SELECT tblLocationIDsAddresses.numLocationAddressID
FROM tblLocationIDsAddresses;

cbLineID
SELECT tblFacLocAddIDsLineIDs.numLocationAddressID,
tblFacLocAddIDsLineIDs.LineID
FROM tblLocationIDsAddresses INNER JOIN tblFacLocAddIDsLineIDs ON
tblLocationIDsAddresses.numLocationAddressID =
tblFacLocAddIDsLineIDs.numLocationAddressID;

I need cbLineID to list the [LineID]'s according to the
[numLocationAddressID] as selected in cbFacilityID.

Set cbLineID's row source to:

SELECT numLocationAddressID, LineID
FROM tblFacLocAddIDsLineIDs
WHERE numLocationAddressID = Forms!theform.cbFacilityID

Then use:

Me.cbLineID.Requery

In both the form's Current event and cbFacilityID's
AfterUpdate event.

 

[Marshall Barton]

Since I mistakenly posted this here I also posted it in the Forms Coding
section. Dale Fye gave me almost the exact directions but didn't mention
putting Me.cbLineID.Requery in the form's Current Event. What happens if it's
not in the Current Event? I've tried the form without it in there and it
appears to be working properly.

If it's not in the Current event, then cbLineID will not
sync up when you navigate from one record to another, so it
might display blank instead of its value.

 

[JohnLute]

Ok - I popped it in there. Always so much to consider!