After Update needed, using two combo boxes on main form

[cimoli]

I don't know how to make the records fire up. I need an After Update, I think, in the second combo box. Can you help me or point me to an article?

There are 2 combo boxes: cboFlcMajorID and cboFlcMinorID.
Their underlying table fields are text. their answers are like 015 or 022 or 777. Unfortunately, the company started their codes with zero. Anyway.

I have the 2 combo box in sync. No problem there.

In the 1st combo cboFlcMajorID, I have an After Update of:

Private Sub cboFlcMajorID_AfterUpdate()
Me.cboFlcMinorID = Null
' Requery the Flc Minor Pick combo
Me.cboFlcMinorID.Requery
End Sub

In the 2nd combo box cboFlcMinorID, is where i am stuck.I bet that i need an AfterUpdate here in order for the records to come up.

For example, if i choose 015 for the major and 010 for the minor, i would like to see 4 records appear. I use a Reset button to bring me all records again.

Can you help me? would you prefer a shorty file posted in my File Dropper? thanks so much. I hope that i answered everything.

 

[cimoli]

Just in case, I put a tiny file if you need to see it.

I want to pick a major and minor and have the records related pull up. The 2 lookup fields are at the very top with a yellow boarder.

I looked around the webs and also hear, and i don't see my problem answered. So I did try.

Thanks you.

 

[cimoli]

Is there a way to post my mini small test file to somewhere here?
Does it need to be zipped

 

[cimoli]

I put the mini file onto mediafire .....

http://www.mediafire.com/?dn7cah5gzh3bhr4

thanks

 

[cimoli]

OK. I had a new idea. Newer file version 3 attached. And I will stop now.

I put an afterupdate in the lookup field at top called cboflcMinorID. And on the row source, i added a concatenated field named MajorMinor. And i added a vba afterupdate. Just winging it. I do not know vba.

i was hoping that MajorMinor would talk to the MajorMinor on the form (plan to make invisable later on). But no go.

So stuck but getting closer.

 

[cimoli]

Never mind. Figured it out. Please delete this post since it did not go anyware.