Recent content by Guernsey Gaz

OK I am trying this a differnt way, I have taken off the limit to list, that way the contact new record will have the details in the contact table. I have done an Append query to append the country and city fields in the CountryCity table from the Contacts table. I have the City in the...

Hi All Still having trouble with this, even if I use a single list of countries when I add the city it adds a new record to the CountryCity table but dosn't have a country to go with it. I need to add countries and Cities. If I add the country and then add the city I want them as a record my...

Thanks Doco But if I have a list of all countries I still only want the second combo to return cities that are in that country Gaz

Hi All, I have a db that has a table called tblCountryCity it has two columns the first being the Country the second being the City The table is not linked to anything as it is just used to get Country and City into other tables. The Country field has many duplicates, not a problem. I have a...

Hi Kempes Excellent, Just what the doctor ordered Many Thanks Gaz

Cascading Comboboxes :(Hi, Havn't had a reply to the problem yet, so here is the code and a reminder of what is going on I have a form called frmCorespondence that is used to enter details into a table, no problems if using just the lookups, but that is not what the client wants. In the real...

Hi Kempes Sorry have been at work all day I have converted to 97 format Hope this helps?

Hi Kemps OK I need help? I have tried and tried to get this db to work. The client wants the two combo boxes on the form Last Name and First Name Also they want the Investor Name as a combo but it must only return those Investor Names that match the Last and First Names On the frmCorrespondence1...

cbo is Combox on your combox in your form in the properties the name will be comb23 or any number Change it to cbo then give it a meaningful name, normall what the combobox does. Gaz

Hi 12BM34 I got this code from Martin Green at fontstuff.com just change the names of the cbos and fields to match your form Private Sub cboLastName_AfterUpdate() On Error Resume Next cboFirstName.RowSource = "Select tblClientDetails.FirstName " & _ "FROM tblClientDetails " & _...

Hi Kempes My tables are linked by IvestorID as a PK in the tblInvestorDetails and InvestorID as a FK in the tblClientsDetails. TblInvestorDetails InvestorID InvestorName Add1 Add2 City Country PostCode Phone tblClientID ClientID InvestorID FirstName LastName Add1 Add2 City Country PostCode...

Hi All Continuing with a form, I have a form based on a query, this form has two combo boxes Last Name and First Name. When the user selects a Last Name the second combo offers a list of first names that match the last name. (Thanks to Martin Green for this) Thes two boxes are from the...

Thanks Bob Works a treat, and have tipped your scales Gaz

Hi Bob How do I do this? I tried in the properties box to = cboCountry but it dosn't update the table with the chosen country I'm a newby in too deep

Hi All I have a form frmClientsDetails based on a table tblClientsDetails. On the form I have an unbound cascading combo which allows me to select a Country from a Country_City table, this in turn changes the cboCity Combo list to reflect the Cities of that Country and I can choose the city...