Search results

JBB, Thanks again... maybe I am being dense... however, what I need to happen... is if a user selects N/A from combo1... I need combo two to populate 3P. Which is a specific item in rowsource. I can get the box to populate the list no problem... I just can't get the combo2 to list that...

So I am trying to write a code to say that If any other value in the Master Combo is chosen other then "N/A" Then populate Job Band ID combo with "3P". Which is a row in the underlying JobBand Table. Not sure if your suggestion will work.

John, Thanks for the help... my only concern is that I don't want to reference a rowsource but a particular value in the rowsource.... not sure how to do that.

So I have a combobox with a 7 different options... I would like to autofill 4 bound combos with a specific value. I am not sure the SQL statement to handle it. So far I have: If [ThirdPartyID] <> "N/A" Then cboJobBand.Rowsource = SELECT tblJobBands.JobBandID, tblJobBands.JobBandName...

Thanks for your help as usual Bob... rowsource is set to qryInfo and the rowsourcetype is FieldList... what the ultimate goal I have in mind is for a user to select the field to filter the query. Based on the combo selection the user would be able to see the choices in a multiselect listbox...

For some reason I think the rowsource of the listbox isn't correct. SELECT qryInfo.[First Name], qryInfo.[Last Name], qryInfo.[System Name], qryInfo.Department, qryInfo.BusinessDescription, qryInfo.Manager, qryInfo.[Job Band], qryInfo.ThirdPartyCompany, qryInfo.Email, qryInfo.[Pulse ID] FROM...

I figured out part of it... the qryInfo had AND statements instead of OR. Here is the SQL... SELECT DISTINCTROW tblEmployees.[First Name], tblEmployees.[Last Name], tblEmployees.[Pulse ID], tblSystems.[System Name], tblEmployees.Email, tblDepartment.Department...

I think I am being really dense, but I can't seem to get the listbox to populate based on the combo selection. The combo's rowsourcetype is FIELD LIST and the rowsource is a query: SELECT DISTINCTROW tblEmployees.[First Name], tblEmployees.[Last Name], tblEmployees.[Pulse ID]...

JDraw... I have attached the db.. I got rid of some the non-pertinent proprietary information that will be stored within... The combo box populates the listbox on the right... It is based on a query. The listbox on the left is populated by a dummy table that I was hoping would move the items...

The video is great... but it doesn't have the combo example. I need the user to not have the option of choosing the same Ent. Because once the user was finished and needed to save the info, I wouldn't want it to duplicate.

Thanks DCrake... your example was the basis for everything that I have been trying to do. My form is just slightly different then yours and am not sure how to change it. My right listbox is a query of the joiner table of tblSys and tblEnt. It shows which Ent is linked to each Sys. Now there...

I agree with you... however, the combo box throws a wrinkle in it. I could get it to work if the combo box didn't need to be involved. Each Sys can have multiple Ents... There are already multiple Ents established with each Sys. For new Sys's its not a problem. For existing Sys's I need to...

Agreed with everything you said. I understand the mechanics of it... however, I am not sure how to code it. Just for clarification here are the tables associated with this: tblSysEnt: SysEntID SystemID EntID tblENT: EntID EntName tblSys: SysID SysName tblSample EntID EntName EntYesNo...

Ok... I have two listboxes. I want to be able to select information from the left listbox and be able to move it to the right listbox. I created a table with option boxes to be able to choose yes/no to make it easier. The rowsource for the left box is: SELECT tblSampleEnt.EntitlementID...

Bob - I know you are a busy guy... didn't know if you had any further thoughts on my last post... I feel I am so close and I think I have the rationale correct, just not sure how to get to the finish line. thanks.

Here is the sql statement for the Query that is the RowSource for the other listbox... SELECT tblEntitlements.[Entitlement Name] FROM (tblSystems RIGHT JOIN tblSystemEntitlements ON tblSystems.SystemID = tblSystemEntitlements.[System ID]) LEFT JOIN tblEntitlements ON...

It should be there now.

See the screenshot... The combo box controls the one listbox. So you can see what entitlements are for what system. You answered a big question already... just trying to see how I can loop in the combo box.

Bob, that's awesome. One more question then I think I can figure the rest out... how would I link the combo selection to the one listbox? I have to be able to code to match up entitlements between the sample data and the actual table. It would have to look down the system id and then match up...

Thanks John.