Adding new entry on combo box?

[jackie77]

Hi all

This is probably a really simple question but one which I cannot find the answer too, I have an data entry form in my db which allows me to enter in a new job ( job id, customers address, postcode etc) but as we do a lot of work in the same area a lot of the addresses are the same (just different house numbers) I was looking to set it up so that when we type in the first few letter of an address for example 'ma' it will suggest main street as an example as I have already got a record with this address. I have look at a lot of other treads which suggest using a combo box but when I have set this up it will not allow me to entry a new address as an error appears and states I must select one from the list, is there a way to allow me to enter a new address if it has not been entered before ? I'm using access 2007

Thanks

Jackie

 

[odin1701]

Probably the easiest way to do this is use a combo box to select from existing addresses, but if you need to enter a new one, use a command button to pop up a new form which will allow you to enter a new address.

 

[jackie77]

Hi there thanks for the reply,

I can understand how that would work but I would have to restructure my table design and add in an address table, estate table and a postcode table as I want a combo box on each of these. At the moment I am just getting the combo box to look up the address on my main table, do you know of a way that I can just check and see if I have entred that address before?

Sorry to be a pain I just don't want to change the table structure to much if there is any other way around it, as its only to save entry time!

thanks

Jackie

 

[ajetrumpet]

I was looking to set it up so that when we type in the first few letter of an address for example 'ma' it will suggest main street as an example as I have already got a record with this address. Do you know of a way that I can just check and see if I have entred that address before?

You can use any number of controls to do this. If I were going to do it, I would have an input text box and then a button to run a criteria query to give me a list of options to choose from...

WHERE [address] = [text box] & "*"

I have set this up it will not allow me to entry a new address as an error appears and states I must select one from the list

Most likely, the error appears because the limit to list property of the box is YES.

I was looking to set it up so that when we type in the first few letter of an address for example 'ma' it will suggest main street as an example

I'm not sure if there is a way to automate that (I'm guessing there's not)...but you can do it alternatively with the query.

 

[jackie77]

changed limit to list to no and it works great many thanks

jackie