Recent content by tonylomax

Thanks for the reply. I managed to create a temporary workaround which is another combo box where the control source is the Keyword text field. The user has to make 2 identical changes on the subform to ensure the table has the correct data. This combo box doesn't update the related ID in the...

In my database I have a main form view and a subform that allows each individual record/person to have various 'keywords' assigned with that person. Each Keyword can be assigned to multiple people and people can have more than one keyword so I have a junction table set up to model the...

@The_Doc_Man I've taken a break and come back to the issue hoping a solution would have occurred to me - it hasn't. Assuming !Email does not exist, which seems likely, is there anything I can do to re-instantiate the object?

@Minty The form does close however I've figured out what I needed to do. I didn't realise you needed to specify which column was bound even if you only have one column visible on the combo box. I change the bound column and now I can run the search in the way I wanted. Thanks for the replies...

Thanks for the replies. @MajP I've adjusted the query as suggested and no luck, I get an Undefined Function error. @Ranman256 I will look into your suggestion though that would make the interface to my database inconsistent between different searches. i.e. I have other queries that work in the...

I'm trying to create a query that uses the selection of a single combobox as part of the WHERE clause. The query: SELECT Database.Contact_ID, Database.[Full Name], Database.[Job Title], Institution.Institution, Database.Email, Database.[Email 2], Database.[Work phone]...

Thanks for the replies. in the end I went with something similar to what @Ranman256 suggested. I was trying to avoid this and it meant I had to create new queries, forms etc but in the end it was the easiest option! Thanks again

@theDBguy Would that not require adding a parameter to the table each time a user runs the search? @plog apologies I probably wasn't clear - when I say different iterations I mean they are technically different queries/forms, but the SQL/form looks identical so the user can have functionally...

I have a query that allows the user to input the parameter and returns records on that basis. This works fine and displays the results on a form. What I want is to display the user input on that form so if the user has multiple iterations of the form open they know which results set corresponds...

@The_Doc_Man Thanks, I'm still pretty new to Access/VBA so not had much look with the code you suggested however I've been using Debug.Print to look at the recordset and the email field is showing up as NULL. @arnelgp This hasn't worked though I think it's definitely some issue with the...

Thanks for the suggestion tried it and no joy, the only difference is that when I hover over it, it does shoe the first entry in the email field which it doesn't on my original code. @Gasman Good question, I don't know and should point out that I didn't create this query

KeywordSearch is the source yes and yes I've checked the button and the spelling of everything a few times. When I debug I get this: KeywordSearch Database.Contact_ID Database.Full Name Database.Job Title Institution.Institution KeywordSearch Database.Contact_ID Database.Full Name...

Yes it it!

No the only multivalued field is one called Keywords.

Thanks for the replies! @Minty Yes that's exactly what I'm doing with the form I've tried removing the multivalued field from the form and the issue persists. I might try and change the query itself to see if that does it. @The_Doc_Man The highlighted field is "If Not IsNull(rs!Email)...