Recent content by Topham

Hello Guys, I have a section of my form that may contain no data what so ever and therefore i need to have a code that if theres no data a field to put a space and if there is a value to put the value in. Heres the code im using and yet im getting Error 94 Invalid use of null If...

Hello im new to VBA and im trying to get one button to do 2 things depending on a value in a certain field of a form. Please see code below. Regards,

I dont want my form based on a query, just want to button to put the data results from the query into the relevant 2 fields.

I have a created a query that filters a table. The data is shown is CustomerID,FName,SName. There is a Field that alread has the CustomerID in and i have a button to open the query with the criteria of what ever the ID is in the CustomerID field. This all works great but how do i go about...

Thanks working now.

When i click debug its showing like this: Everything is showing fine.

Const rSource = "SELECT Contacts.CustomerID, Contacts.FName, Contacts.SName, Contacts.Title, Contacts.OrgName, Contacts.AddrL1, Contacts.AddrL2, Contacts.TownCity, Contacts.PCode, Contacts.CountryRegion, Contacts.PhoneLL, Contacts.PhoneMob, Contacts.Fax, Contacts.EMail...

its still giving error hmmm

I keep getting Compile Error: Tyoe Mismatch

Im using this code if it helps: Private Sub Open_Search_contacts_form_Click() If Me.[Open Search contacts form].Caption = "Search Name" Then Me.Filter = "(FName Like [First Letter of First Name]) And (SName is [Surname])" Me.FilterOn = True Me.[Open Search contacts form].Caption =...

Sorry im lost now. If i base my form recordset on that query each time i open the form it will prompt for the filters each time. I only want to to prompt for the filters when im searching for a particular customer.

what would the code be to apply 2 filters on for Firstname and the other for Surname using the same button?

WOuld it be possible to prompt for the filter instead of having text boxes in the header?

Would it be wise to create a query for all the contacts are viewed and then apply a filter through VBA?

The form views all the records which is in the Contacts Table. I have created a search button that Opens a Query which prompts for the 1st Letter of the 1st name and prompts again for the whole surname. Once done the query shows the result fine. But how do i get the form to view the result?