My current problem is pointing Form “Beginner Pictures” to the correct external folder “Beginner_Pics”. My previous endeavor with Form “Gallery”retrieves Photos from external folder “Gallery_Pics”. I developed both Forms ComboBox using DataPigTechnologies instructive video. The following areas were reviewed for errant code:
Form “Beginner Pictures” Property Sheet, Property Source contains the desired “Beginners Carving Query”
ComboBox "BcNr_Select" Property Sheet: (1) AfterUpdate entry contains all new fieldnames except for Table Fields and the logic is similar to the working "Gallery" Form. It also has the changed code for the FileNmBld = "Beginner_Pics\" & JPEG_Id & ".jpg" (2) RowSource contains: SELECT [CarvingTable].IDCarv, [Carving Table].CarvingNR FROM [Carving Table] WHERE ((([CarvingTable].IDCarv) Like [Forms]![Beginner Pictures].[BcNr_Select] &"*")) ORDER BY [CarvingNR];
Yet the comboBox displays the values for “Gallery_Pics” instead of “Beginner_Pics”. Where else should I look for errant/missing code? TIA Phil