Visitor data input form

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: a_schriver (a_schriver_at_discussions.microsoft.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 09:31:02 -0800

I have a geodatabase with city, state, and coordinate info. I want to be able
to enter the state on the input form and have the cities in that state
selected to be available in the city field. Example: if I want to enter
information for a visitor from Paris, TN, I would enter TN in the state field
and I would have a dropdown in the city field that would only show cities in
TN to pick from where I could select Paris. Now I enter TN and enter Paris
but I get the geodata from the first city named Paris in the database which
could be Paris, TX not Paris, TN.
Or I could set the form up the other way. Enter the city first and then have
only the states with a city of that name show up in the dropdown for state
field.
I just don't know enough about forms.

Relevant Pages

  • Re: Cities in Fantastic Fiction (Repressentative and otherwise)
    ... me to be similar to the photos I've seen of mostly Midlands cities. ... > of any British city and I suspect there's a fair slice of fin-de-siecle ... I always connected the quietly desperate poets of Viriconium with Paris, ... ;) in fantastic fiction, and a sort of City of God? ...
    (rec.arts.sf.written)
  • Re: Visitor data input form
    ... > to enter the state on the input form and have the cities in that state ... > selected to be available in the city field. ... > TN to pick from where I could select Paris. ...
    (microsoft.public.access.forms)
  • Re: Lots of questions about Paris
    ... Paris is a wonderful city and I'm sure you'll have a great time - if I ... area of Paris - cab, ... you'll need to buy your bus ticket from one of the ...
    (rec.travel.europe)
  • Re: de Tocqueville and Chicken Hats
    ... city is Paris, ... brownness never associated with French womanhood. ... As it turned out, the Germans laid mines, all ...
    (alt.gathering.rainbow)
  • Re: de Tocqueville and Chicken Hats
    ... city is Paris, ... brownness never associated with French womanhood. ... As it turned out, the Germans laid mines, all ...
    (alt.gathering.rainbow)