Re: Visitor data input form
From: fredg (fgutkind_at_example.invalid)
Date: 01/17/05
- Next message: Rachel: "Synchronized Combo Boxes."
- Previous message: Sprinks: "RE: passing null strings"
- In reply to: a_schriver: "Visitor data input form"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 Jan 2005 18:42:30 GMT
On Mon, 17 Jan 2005 09:31:02 -0800, a_schriver wrote:
> 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.
Set the List box RowsourceType property to Table/Query.
Leave the RowSource property of the List Box blank.
Code the [State] AfterUpdate event:
Me!ListBoxName.RowSource = "Select [TableName].[City] from [TableName]
where TableName.State = '" & Me![State] & "' Order By [City] ;"
-- Fred Please only reply to this newsgroup. I do not reply to personal email.
- Next message: Rachel: "Synchronized Combo Boxes."
- Previous message: Sprinks: "RE: passing null strings"
- In reply to: a_schriver: "Visitor data input form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
