Search results

when i did that, i got the attached screen :confused:

deleting the control just made it so I can no longer "go to" a specified record. I can still search for a record from the standard "search" box. from the messages I've been getting (error 2950) and others, it seems I may have started from a older version of Access and now it cannot update to my...

I tried both of your suggestions, and it still is not working, clearly I am missing something. I am going to just delete the field. Thanks for your help, I appreciate your time!

i have an unbound "go to" box that has the row source as: SELECT [ID], [Contact Name], [Company], [E-mail Address] FROM [Contacts Extended] WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Contact Name];

perfect. .. here it is: SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last...

sure, but how do I just attach the query? Sorry to be so lame!

Hello - I have a similar situation. Have a contact detail form, linked to contacts extended query. When I open the contact detail form I get "enter parameter value - form!id. I've checked the contacts extended query and can't find a "form!id"?? Any suggestions??

Worked perfect! Thanks! appreciate the help!

this is helpful, but how can i get a total I have in a sub-form (located in the footer of the sub form) to display in my main form?