Recent content by qwerty99

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.