a Query that will select when to fill in the address

[Joceline]

hi all,

I have a form that is set up for the users to select from a drop down list the name of the association. I would like to have it that if the association is selected, then the address would automatically be filled in with the proper coordinates as per the chosen association.

I hope that I have explained my issue well enough to get a response.

 

[jdraw]

Where will the address info come from?
Do you have a table of addresses by association already?

Until we know more, that's about the limit of responses.

 

[Joceline]

sorry for the lack of information.

I have a form that is set up for the users to select from a drop down list the name of the association. I would like to have it that if the association is selected, then the address would automatically be filled in with the proper coordinates as per the chosen association. I have a table for the associations with all the information regarding the association.
My goal would be that if a user selects an association, then the address would be automatically filled in.

is this a bit clearer?

 

[jdraw]

A little, but is the address for the association in

I have a table for the associations with all the information regarding the association.

 

[Joceline]

yes I would pul the information from a different table. would this involve building an event procedure?

 

[jdraw]

You could have a form whose record source was a query that contained info about associations and whatever else is related. Your combo (dropdown) could get its data from your association names (and the associationId could be hidden).

A filter to only show the info for the selected Association could be activated based on the selection from the dropdown.

There is a free video here that may help
http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

 

[Joceline]

Ok, so if i'm setting this up on the form itself, I would change the properties of the combobox to select a query? would this fill in the address sections automatically or would I have to have the query stating where the information should be updated. I would need to have my fields match.

sorry for all the questions, but i'd really like to have this option available to the users.

what if i create a y/n button where they would select if it's address 1, then fill in address, if it's address 2 don't fill in address. is this a better option?

thanks in advance for all your help, trust me when I say it's greatly appreciated!!!

 

[Simon_MT]

If you store the Association you should able able to join to an Associations table without having to any input.

Simon

 

[jdraw]

If you have all of the info for associations, and you're pulling the address from a different table, where does where the information should be updated fit in?

What is the purpose of your application?
Do you have the address info already or not?
I don't understand what you're updating.

Based on the video, which I thought might be appropriate to your needs, your form is bound to a table or query containing association info. You can have a drop down to filter your records, based on name, or address, or phone... but you have to have the data.

 

[Joceline]

Hi,

thank you for your response. What I'm trying to accomplish is that I have a 'data entry' type form. In my form I've created a drop down list for the 'association' that the contact person belongs to. I also created a table for my associations that contains all the contact info. this is what I would like to link to.

What I want is that when they select the 'association' from the drop down, it will automatically fill in the 'association's address' in my form.

I watched the video you sent me, but I still wasn't clear if this was what I was trying to do. I'm still at the beginners stage of Access, so I apologize if I don't quite understand.

thanks in advance for all your help.