Address Finder

Number11

Member
Local time
Today, 04:11
Joined
Jan 29, 2020
Messages
624
So i need to create a form that the user enters the Postcode and then have a combo box to select the house number and then populate property details in other text boxes, is this something easy to do
 
ok i have done it following this method


  1. Open the Employees database.
  2. Click Forms under Objects in the Database window, click the New button, and then click OK. In Access 2007, click the Create tab and then click Forms Design in the Forms group.
  3. Click the Combo box control in the Controls toolbox. In Access 2007, click the Design tab under Forms Design Tools and click Combo Box (Form Control) in the Controls group.
  4. Click and drag in the form where you want to locate the control.
  5. Click Next.
  6. Select the Employees table and then click Next.
  7. Select the Employee ID, Last Name, First Name, and Phone Number fields.
  8. Click Next.
  9. Click the drop-down arrow in the first text box and click Last Name.
  10. Click Next.
  11. Adjust fields as necessary and then click Next.
  12. Enter Employee Contact Form and click Finish.
  13. Click in the Combo Box label control and change the label to Last Name.
  14. Click the Text Box control in the Controls toolbox (Access 2003) or the Controls group (Access 2007).
  15. Click and drag to create an unbound text box control below the combo box.
  16. Change the text box label to First Name.
  17. Click the Text Box control in the Controls toolbox (Access 2003) or the Controls group (Access 2007).
  18. Click and drag to create an unbound text control below the first text box.
  19. Change the text box label to Phone Number (Figure A).

Figure A​

  1. Right-click the combo box and select Properties.
  2. Click in the On Change property box in the Event tab and select Event Procedure.
  3. Click the Build button and enter this code (Figure B):
Me.Text19 = Me.Combo17.Column(2)
Me.Text21 = Me.Combo17.Column(3)

Figure B​

  1. Add an error handler to the On Change event subroutine.
  2. Press [Alt] + [Q].
 
Give your controls meaningful names. :(

6 months down the road Me.Text19 is going to mean squat :(
 
I think you might need to upload a sample database with some forms.
A great wall of text describing building a form isn't helping anyone to help you.

How is your data stored? Can you show the table design and relationships?
Unless you have a postcode/road name/ house number table (which would be 100,000s of records) I'm not sure how you would do this?
 

Users who are viewing this thread

Back
Top Bottom