Form unbound field control problem?

[justphilip2003]

Try the ControlSource of Image control. The ControlSource of Image control can be attachment field, text field storing path string, or an expression that constructs the path string. A function can be in the expression. Or VBA can set the ControlSource property.

It wouldappear that my DB problems have narrowed down to a malfunctioning query! When I select a combobox value of"58", the msgbox messages show "1" as being selected not “58"and record "103" is sought. "IDCarv" is the table primary key.In the Table, CarvingNR "58" has a primary key of "1". In another test I select the combobox value"43", the msgbox showed "45" and "103" wassought. CarvingNR "43" has a primary key of "45". Why isthe PK being returned as the as the combobox value selected? Is this query criteria {
Like[Forms]![Gallery].[Select_CrNr] & "*"} at fault or the
the combobox row source: {SELECT[CarvingTable].IDCarv, [Carving Table].CarvingNR FROM [Carving Table] ORDER BY [CarvingTable].CarvingNR;}?

TIA Phil

[June7]

IDCarv is returned I expect because that is the combobox BoundColumn. Why don't you use the PK field as filter criteria? If you must use CarvingNR then reference the combobox column by index. Index begins with zero.

[Select_CrNr].Column(1)

[justphilip2003]

IDCarv is returned I expect because that is the combobox BoundColumn. Why don't you use the PK field as filter criteria? If you must use CarvingNR then reference the combobox column by index. Index begins with zero.

[Select_CrNr].Column(1)

I have addressed the combobox issue by eliminating the PK in the code and making the combobox a one cdolumn item. What I feel is the problem is the query criteria {Like[Forms]![Gallery].[Select_CrNr] & "*"}. Every selected combobox value ends with a search fo CarvingNR 103. I think my criteria causes the query to search for all records that fit the argument and returns the last record searched. If I am right then I need a criteria that uses a FindFirst argument but I do not know how to write it with the correctthe syntax. Do you agree with my observation? TIA Phil

[June7]

The query should return all records that meet the criteria parameter. Why would 103 always be the input?

The only use of FindFirst I am aware of is in VBA code to search a recordset. Don't know what you are thinking of nor how it pertains to dynamic parameter query.

[justphilip2003]

I am attempting to explain why the query bypasses the asked for record and always goes to the record containing carvingNR 103. I click on the desired value in the combobox and the first instruction in the combobox AfterUpdate() is a msgbox that has a toggle break and there the record 103 is displayed. is it possible the order by code in "SELECT [Carving Table].CarvingNR FROM [Carving Table] ORDER BY [Carving Table].CarvingNR;" is causing my problem? TIA Phil

[June7]

No.

Are you using this combobox to filter the form recordset? The combobox sits on the form you want to filter? Is this combobox UNBOUND? It must be UNBOUND to serve as filter criteria input, otherwise you will change the value in record. Show the VBA code associated with the combobox.

[June7]

Discussion on this issue continued in https://www.accessforums.net/queries...sue-34112.html

[justphilip2003]

Carving Table.txt Hopefully this attachment contains a text format of my Carving Table. I use the combobox to select a unique carving number. The several of the associated fields in the record are displayed on the form and the field JPEG_Id contains the file name for an image display. The problem has been that the query always returns CarvingNR 103. TIA Phil