Unanswered: VBA question boxes? More help on my postcode DB please!!! :)
OK.... thanks all for your help so far.
My database now allows me to key in a UK postcode and autocompletes the street name, town and county on the form in use. Now being rubbish I don't know how to do this next bit... is there any way in my VBA that I can add in a function that pops up a box and asks for a house number and then adds it in to the beginning of the street name.... my script so far goes like this...
Private Sub Post_Code_BeforeUpdate(Cancel As Integer)
Dim Strg As Variant
Dim Strg1 As Variant
Dim Strg2 As Variant
If Not IsNull(Strg) Then
Dim HouseNum As String
HouseNum = InputBox("Please enter the related house number...", "House Number?")
If HouseNum <> "" then Strg = HouseNum & " " & Strg
Me.Address_Line_1 = Strg