Search results

@June7 True, but then again the OP has to date only stated that they wish to eliminate the duplicates and has not outlined their wider objective

Perhaps a GroupBy/Totals query would be the way to solve the duplicate issue?

Ah of course

What is the purpose of the two tables tblMember and tblMember_2 they both seem to be holding identical information about members :unsure:

UPDATE tblCustRFQDtls LEFT JOIN tblCustRFQHdr ON tblCustRFQDtls.RFQHdrID = tblCustRFQHdr.RFQID SET tblCustRFQDtls.Flag = "False" WHERE (((tblCustRFQHdr.ConsigneeCode)=[Forms]![FrmCustRFQHdr]![ConsigneeCode])); You need to wrap the True/false in double quotes or simply use -1 instead of True...

Sorry I can't post a direct link yet, but use your preferred search engine and search on "Refer to Form and Subform properties and controls" look for a result in access dot mvps dot org should be near the top of the results. This site has the correct syntax for referring to forms/subform from...

That's the one I got an error when I tried to post a link to it :rolleyes:

I know I'm late to the discussion, but search in sample Database section of the forum for "Dynamically search multiple fields" and have a look at that DB, it's a really handy example

From your screenshot, it would appear that you have the Combo's "Column Heads" set to "Yes". The [ListCount] function will count the header as an item in the list so simply set your code to =[Name_of_combobox].[ListCount]-1

Thanks, for the heads up Uncle Gizmo :)

Why such paternalistic concern over how I choose to spend my time :unsure:

Thanks, I was thinking if it were possible that it would be something along those lines

I suspect I know the answer to this question (and it is "NO") already, but just wanted to check; Is it possible to format the Form Caption, i.e. to change the colour of the text, partially or wholly, or bold /italic it?