Search results

Ooops,...cut off some of the event procedure: Private Sub Form_Load() 'sets the list for the first Combobox Me.Combo142.RowSource = "SELECT [CCode].[CCode] " & " FROM CCode ORDER BY CCode;" Me.Combo142.Requery End Sub __________________________________________ Private Sub...

The tables "CCAH" and "CType" contain the codes for CType. The filter for the list box should be based on the selections made for CCode/PGCode/PDCode to give me a shortened list of CID's from the table "MasterCID". Here are the event settings for CCode: 'sets the list for the first Combobox...

Option Button --> CType two tables for CType Then PGCode --> and PDCode --> to show results for CID in the "Last CID" ListBox.

Just one form in the dB I forwarded.

I gave them the choice of getting help or scrapping the project. They chose to move forward.

Here you go....

Just had a meting to set up a dummy version of the dB. Let me get it ready and I will forward it to you once I am done.

My company doesn't allow me to share.

I just joined this week to get help with an issue I am having on the dB I created. I am a contractor, as a Data Analyst/Business Analyst. Usually use Oracle or MySQL, but have experience with Access (slightly rusty). The response I have received in providing assistance to me has been...

Would DLOOKUP work for me?

I'm searching for a similar solution except that I have 3 Combo boxes (independentof each other, not cascading) for the user to select from on the form. I want that to be, essentially, the filter for a list box on the Form showing the ID associated with the 3 Combo boxes combination. Any...

CType (also part of the event procedure: SELECT [CCode].[CCode] FROM CCode ORDER BY CCode; CCode CType: SampleData= ABCB BLOM CLOM DPOM YYMM _______________________________________ CCAH CType: SampleData= 1505 1504 1503 1502 1501 1412 etc. _________________________________ PGCode Combo Box...

burrina: I'm not sure I follow...Which Combo box should I attach this code?

Combo142 is not what it is actually called. I de-identified my fields at the request of my manager.

CID table: ID (AutoNumber, PK) CID (UNIQUE) RID Frequency CType (CCode) PGCode PGCodeID PDCode PDCodeID CIDNo CreateDate (=Date()) EmployeeID EmployeeName Combo142 can be one of two tables Auto and CCAH, which are the CType ID CID RID Frequency Type CType PGCode PDCodeID PDCode...

I have attached the text file as requested. I can't thank you enough for helping me out.

Option one sounds best. Thanks

"I still don't completely follow. Can you give the hierarchy of your combo boxes and listbox. Does the user select an item from the listbox, which then filters Combo1, and Combo1 filters Combo2 etc? Or Does the user select an item from Combo1, which filters Combo2 etc, which then filters the...

The list box is where I want the result to be displayed. There is a main table (MasterCID) that uses the form [CID Gen] to add a record to the table. Prior to adding the record to the table the end user will filter CID in a List Box (LastCID) to show which CID's have been used already. Each...

I agree, progress is being made and I am hopeful (determined) to get this to work. I was not offended in any way by the Color/Bold of the font. trust me, I am frustrated too (lol). Thanks for the encouragement. I sent a screen shot of the DesignView of the form, in the chance that may help...