Search results

nanscombe I got it to work be specifying the form. Thanks!

Tried it and it's still showing all of the records.

I tried that but now the opened form doesn't reflect the name at all (even if there isn't an apostrophe) and instead is showing all of the records. Thanks for you help btw!

I have a button in one form that opens a different form and want it to show specific data to display. I choose this option in the command button wizard and set it up to have the name from my main form be the same name as my new form to be opened. Everything works perfectly until I choose a name...

I just tried to save it as a 2003 file format, but it's telling me I cannot save the database in an earlier version format because it uses features that require the current file format. Is there some way around this?

I have a form that I need to update whenever a chosen business name changes. This is tied to a search function that updates/changes the business name, and this works fine. What I now need it to do is when the name is clicked on the table (which updates the respective business name) I need...

I have a form that acts as a search form where the user inputs a string of text which then updates and filters a list box. For some reason when it does this it highlights the 2nd row on that list, even if there is no data there. How can I get it to automatically highlight the first row? The...

Beautiful. Thanks for the quick reply.

I have a field in a table that is to be concatenated from two other fields, PolPrefix and PolNum. On a form I got it to show the full field 'PolicyNumber' by making the control source =[PolPrefix] & [PolNum]. But this doesn't update the field PolicyNumber in the respective table, and only shows...

So how do I bind the combobox to the data while still allowing for the "Show All" button to work? I can only get one or the other to work, but haven't been able to get them both to do so.

Thanks for explaining why it wasn't working. However, now when using the arrows or search at the bottom the business name doesn't update, but everything else on the form does, and choosing a business name from the drop down list doesn't update the fields in the form. How would I go about getting...

Here you go. The form is titled "NavnormF" and "IC" is the tab I'm working with. Thanks.

After using the combobox it still says "No Filter" next to the search field at the bottom. Is that what you're saying should be orange if the form is being filtered?

I have a combobox on a form that lets the user select a business name which then populates the rest of the fields in the form appropriately. But when it does this it makes it so that the seach function at the bottom of the screen no longer works, as it only has the selected record as an option...

It works! Thanks for your help and patience.

I'm sorry I'm still a novice at VBA, but what do you mean by that? Which value?

I have it in the On Current event for the form.

Yes, that is what I'm trying to do. I put the following code in, but its not working: Iff(DCount("WCAccountName","WCInfoT","WCAccountName=ICBusName")>0, "Same Name", "") It keeps telling me "Compile Error: Expected: =" Where WCAccountName is in the table WCInfoT, and I'm comparing...

What if the fields are not in the form's source? The two fields are from different tables and are not related to each other in any way, I just need to know a way of showing if they have the same name. Its unlikely/will be rare to have the names the same, but I still need a way to show if they...

I have two different fields in 2 tables, ICname and WCname, and if there is an instance where they are the same I need to have a textbox on the main form show "Same Name" but if not the box should remain invisible. I have created a query that searches through all the names and only prints out...