Recent content by Olufisola

It worked fine. Thanks a million Paul.

I also have two other tables that their data type is short text e.g. tblLocation and tblColdStore what would change from your solution above?

Thanks a great deal everyone that has contributed, especially bob fitz. The solution worked perfectly. I am so grateful.

Hi Bob, Here is the row source property: SELECT [tblGermplasmYear].[ID], [tblGermplasmYear].[Year] FROM tblGermplasmYear ORDER BY [Year]; row source type: Table/Query

Here is the SQL statement for combo box: Private Sub cboYear_AfterUpdate() Dim myGermplasm As String myGermplasm = " Select * from tblGermplasm where Year = " & Me.cboYear Me.tblGermplasm_subform.Form.RecordSource = myGermplasm Me.tblGermplasm_subform.Form.Requery End Sub Yes, the data type of...

Thank you for your quick reply Paul. After applying what you posted, when I select a year e.g. 2006 from the cboYear drop-down, the tblGermplasm_subform became empty instead of selecting all 2006 associated rows. Please help me out on this, I've been struggling with it for quite a while. Thank...

Hello All, I am in need of urgent solution to this protracted issue I am having with Search Form using Combo box. The error code 3464 - Data type mismatch in criteria expression. The code is pasted below: the issue is with shaded 4 (line 4) Private Sub cboYear_AfterUpdate() Dim myGermplasm As...

My name is Olufisola. I reside in Lagos, Nigeria. I'm a GIS/ICT Consultant. I want to hone my skills in MS Access programming. I look forward to learning and making new friends. Thanks for this platform.