Recent content by WildmanUK

Its amazing how you can look at something for ages and not see the problem then its clear once someone says something! That was the problem the field in Searches is CompanyCode not CustomerCode. Thanks! I would have been here for hours and totally not noticed that.. :S WildmanUK

Hi, I have form with text boxes and a button on one form, the code takes the value of the text boxes and creates a new record in a table from them. I have then replicated the code changing the name of the text boxes etc on another form and i'm getting "Item not found in this collection" error...

Hello, I have a form I designed where it shows a company Code and company name then has a combobox which shows a list of locationCodes. When I select one it then loads up the address and contact details below. I have 3 tables involved Customers, Locations and Contacts, the form is linked to...

Right I seem to have fixed it thanks for replies. I ended up putting the following code in the Current event of the Form Me.ComboLocation = Me.ComboLocation.ItemData(0) Me.Refresh The default value is set when the form is loaded and when the record changes and the subforms update to show the...

I have attached a second preview so you can see the problem more clearly. When the form loads up the combo has no default value, when I open the combo up the other options are listed below the blank space. This isn't that much of a problem when you first load the form but it gets messy when...

Hi, The Customer Code, Customer Name section and the combo box are part of the main form. Then there's a subform for the address part and another subform for the contacts section. I have a query that selects all records from locations where the customerCode is the same as the one currently in...

Hi, Thanks for the quick reply. I have managed to get it mostly working but I have a more cosmetic problem now rather than a logic problem. I have produced a query which selects the locationID from the Location table based on the customerCode of the current record being displayed in the main...

Hello, I am trying to create database and having a bit of a problem getting my head around it, its been a long time since I did anything in access. I will outline the tables and what I want to display and hopefully someone can come up with a easy solution :) Tables: Fields Customer: ID...